Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using Hive/ Enterprise-Class Enhancements of Hive/ Creating a Foreign Table in a Directory (Read and Execute Permission Granted)
Updated on 2024-10-25 GMT+08:00
View PDF
Share

Creating a Foreign Table in a Directory (Read and Execute Permission Granted)

The hive.restrict.create.grant.external.table parameter is used to allow users and user groups with the read and execute permissions to create Hive external tables without checking whether the user is the owner of the directory. In addition, the Location directory of the foreign table cannot be in the default \warehouse directory. In addition, when authorizing foreign tables, do not change the permission corresponding to the Location directory.

After this function is enabled, the function of the foreign table changes greatly. Based on the actual application scenario, determine whether to enable this function.

Procedure

  1. Log in to FusionInsight Manager. Click Cluster, choose Services > Hive, click Configurations, and then All Configurations.
  2. Choose HiveServer(Role) > Customization, add a customized parameter to the hive-site.xml parameter file, set Name to hive.restrict.create.grant.external.table, and set Value to true.
  3. Choose MetaStore(Role) > Customization, add a customized parameter to the hivemetastore-site.xml parameter file, set Name to hive.restrict.create.grant.external.table, and set Value to true.
  4. Click Save to save the configuration. Click Instances, select all Hive instances, choose More > Restart Instance, enter the password of the current user, and click OK to restart all Hive instances.
  5. Determine whether to enable this function on the Spark/Spark2x client.

    • If yes, download and install the Spark/Spark2x client again.
    • If no, no further action is required.