Support Questions
Find answers, ask questions, and share your expertise

I have created a table in hive. What is the command to check it in hdfs ? Pls help i m a beginner.

Highlighted

I have created a table in hive. What is the command to check it in hdfs ? Pls help i m a beginner.

 
3 REPLIES 3
Highlighted

Re: I have created a table in hive. What is the command to check it in hdfs ? Pls help i m a beginner.

Cloudera Employee

you can execute describe command from beeline to know the table path in hdfs.

Re: I have created a table in hive. What is the command to check it in hdfs ? Pls help i m a beginner.

Rising Star

@sganeshkumar

databases are kept in folder /apps/hive/warehouse

If you want to check it in HDFS to see the files associated with the database then use below command

hdfs dfs -ls /apps/hive/warehouse

If you want to access hive command line from the sandbox shell then

first change the user to hive using

su - hive

then run command

hive

on hive command line

hive> SHOW DATABASES;

Note: Please mark this answer accepted and upvote if you find it useful

Highlighted

Re: I have created a table in hive. What is the command to check it in hdfs ? Pls help i m a beginner.

Don't have an account?