Help Center/ MapReduce Service/ FAQs/ Metadata Management/ Where Can I View Hive Metadata?
Updated on 2023-01-11 GMT+08:00
View PDF

Where Can I View Hive Metadata?

  • If Hive metadata is stored in GaussDB of an MRS cluster, log in to the master DBServer node of the cluster, switch to user omm, and run the gsql -p 20051 -U {USER} -W {PASSWD} -d hivemeta command to view the metadata.

    To query the IP address of the active DBServer node, log in to FusionInsight Manager, choose Cluster > Services > DBService, and click the Instance tab.

  • If Hive metadata is stored in an external relational database, perform the following steps:
    1. On the cluster Dashboard page, click Manage on the right of Data Connection.
    2. On the displayed page, obtain the value of Data Connection ID.
    3. On the MRS console, click Data Connections.
    4. In the data connection list, locate the data connection based on the data connection ID obtained in 2.
    5. Click Edit in the Operation column of the data connection.

      The RDS Instance and Database indicate the relational database in which the Hive metadata is stored.

Parent topic: Metadata Management