Help Center/ MapReduce Service/ Component Operation Guide (LTS) (Ankara Region)/ Using Hive/ Viewing Table Structures Using the show create Statement as Users with the select Permission
Updated on 2024-11-29 GMT+08:00
View PDF
Share

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

Scenario

This function is supported on Hive and Spark.

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, 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 client.

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

Parent topic: Using Hive