Created 08-16-2018 04:53 AM
Created 08-16-2018 07:12 AM
you can execute describe command from beeline to know the table path in hdfs.
Created 08-16-2018 07:14 AM
@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
Created 08-16-2018 07:36 AM