Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using Hive/ Enterprise-Class Enhancements of Hive/ Allowing Users with Select Permission to View the Table Structure
Updated on 2025-03-17 GMT+08:00
View PDF

Allowing Users with Select Permission to View the Table Structure

Scenario

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.
  3. 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.
  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.