Help Center/ MapReduce Service/ FAQs/ Component Configurations/ How Do I View MRS Hive Metadata?
Updated on 2024-08-16 GMT+08:00

How Do I View MRS Hive Metadata?

  • Hive metadata is stored in the GaussDB database of the MRS cluster. You can perform the following steps to view the metadata:
    1. Log in to the DBServer active node as user root.
    2. Log in to the Hive database:

      su - omm

      source $DBSERVER_HOME/.dbservice_profile

      gsql -p 20051 -U USER -W PASSWD -d hivemeta

    3. View all metadata tables in the Hive metadata database:

      \d+

    4. Run q to exit the page for viewing the metadata table.
    5. View data in the metadata table:

      select * from Table name;

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

    You can view the default username (USER) and initial password (PASSWD) of the DBService database in User Accounts.

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