Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using Hive/ Enterprise-Class Enhancements of Hive/ Configuring that Location Cannot Be Specified When a Hive Internal Table Is Created
Updated on 2025-08-22 GMT+08:00
View PDF
Share

Configuring that Location Cannot Be Specified When a Hive Internal Table Is Created

Scenario

When creating a Hive table, you can specify the location of the table to an HDFS or OBS directory (in the decoupled storage-compute scenario). However, you cannot directly specify the location when creating a Hive internal table. In this case, you can configure the hive.internaltable.notallowlocation parameter to achieve this purpose. After a Hive internal table is created, the location of the table is created in the default warehouse directory /user/hive/warehouse and cannot be specified to other directories. If the location is specified when an internal table is created, the table fails to be created.

After this function is enabled, if there is a table that points to a directory other than the default warehouse directory in the database, Exercise caution when creating databases, migrating table scripts, and rebuilding metadata to prevent errors.

Procedure

  1. Log in to FusionInsight Manager, choose Cluster > Services > Hive, click Configurations, and click All Configurations.
  2. Choose HiveServer(Role) > Customization, add a custom parameter to the hive-site.xml file, and set Name to hive.internaltable.notallowlocation. The parameter values can be:

    • true: The table location cannot be specified when a Hive internal table is created.
    • false (default value): The table location can be specified when a Hive internal table is created.

    Set this parameter to true.

  3. Click Save to save the settings. Click Instances, select all Hive instances, click More then Restart Instance, enter the user password, and click OK to restart all Hive instances.
  4. 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.

  5. Log in to the node where the client is installed as the client installation user.

    For details about how to download and install the cluster client, see Installing an MRS Cluster Client.

  6. Configure environment variables and authenticate the user.

    Go to the client installation directory.

    cd Client installation directory

    Load the environment variables.

    source bigdata_env

    Authenticate the user. Skip this step for clusters with Kerberos authentication disabled.

    kinit Hive service user

  7. Log in to the Hive client. 

    beeline

  8. Create a Hive internal table.

    If the location of a Hive internal table is specified, for example, /user/test in HDFS, run the following command: 
    create table test(name string) location "user/test";

    If an error is reported after the command is executed and the table fails to be created, the configuration of that the location cannot be specified when the Hive internal table is created is successful.

    Delete the location parameter from the command and run the command again to create the Hive table.