Help Center> MapReduce Service> Component Operation Guide (LTS)> Using Hive> Viewing Table Structures Using the show create Statement as Users with the select Permission
Updated on 2023-04-28 GMT+08:00

Viewing Table Structures Using the show create Statement as Users with the select Permission

Scenario

This function is applicable to Hive and Spark2x in.

With this function enabled, if the select permission is granted to a user during Hive table creation, the user can run the show create table command to view the table structure.

Procedure

  1. Log in to FusionInsight Manager. For details, see Accessing 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.allow.show.create.table.in.select.nogrant, and set Value to true. Restart all Hive instances after the modification.
  3. 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.