How can I access metastore database for Hive inside cloudxlab

Lab Support
#1

How can I access the metastore database inside cloudxlab?? I’m practicing Hive(HQL) and looking for metastore details to understand the table metadata & schema. Thanks in advance

#2

You can use the below command at the Hive prompt to view the path:

set javax.jdo.option.ConnectionURL;

However, I don’t think you have the permission to access it on CloudxLab. Although you can check it in your local system, or any other system containing Hive.

1 Like
#3

ThankQ Rajtilakb, Yeah I don’t have access to metadata DB but good to know the command you posted.

#4

Hi Suresh,

Aren’t you able to find the table metadata and schema using the Hive console?

#5

Hi Sandeep,

I tried many ways to connect metastore but no luck. Please guide me on how to connect the hive metastore database to view the table structures? One more query ,is there any way I could connect MySQL DB or hive metadata store from external GUI-based tools like DBeaver or SQL Developer?? Thanks in advance.

Hive Metastore
Hive Metastore1420×727 109 KB

Regards,
Suresh Reddy

#6

You can use ‘describe formatted’ command.

#7

Hi Sandeep,

Above solution could not help me to get the required details.

#8

We can’t give the access to metastore. That way one user will be able to access other user’s hive table details.

Please use hiveql statements such as ‘describe’ inorder to understand the table structure.

#9

Thanks, Sandeep! I got it