I have created a table in hive, I would like to kn

Question

I have created a table in hive, I would like to know which directory my table is created in? I would like to know the path...

Answer 1

You can use below commands for the same.

show create table <table>;
desc formatted <table>;
describe formatted <table>;

Answer 2

If you use Hue, you can browse the table in the Metastore App and then click on 'View file location': that will open the HDFS File Browser in its directory.

Answer 3

All HIVE managed tables are stored in the below HDFS location.

hadoop fs -ls /user/hive/warehouse/databasename.db/tablename

Answer 4

There are three ways to describe a table in Hive.

1) To see table primary info of Hive table, use describe table_name; command

2) To see more detailed information about the table, use describe extended table_name; command

3) To see code in a clean manner use describe formatted table_name; command to see all information. also describe all details in a clean manner.

Resource: Hive interview tips