I have created a table in hive I would like to know which directory my table is created in

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

User · Answer

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

User · Answer

You can use below commands for the same   show create table  lt table gt   desc formatted  lt table gt   describe formatted  lt table gt

User · Answer

DESCRIBE FORMATTED  lt tablename gt    or   DESCRIBE EXTENDED  lt tablename gt    I prefer formatted because it is more human readable format

User · Answer

All HIVE managed tables are stored in the below HDFS location   hadoop fs -ls  user hive warehouse databasename db tablename

User · Answer

DESCRIBE FORMATTED my table   or  DESCRIBE FORMATTED my table PARTITION  my column  my value

User · Answer

in the  default  directory if you have not specifically mentioned your location   you can use describe and describe extended to know about the table structure

User · Answer

Further to pensz answer you can get more info using   DESCRIBE EXTENDED my table    or  DESCRIBE EXTENDED my table PARTITION  my column  my value

User · Answer

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

User · Answer

To see both of the structure and location  directory  of an any  internal or external table  we can use table s create statment- show create table table name

User · Answer

in hive 0 1 you can use SHOW CREATE TABLE to find the path where hive store data   in other versions  there is no good way to do this   upadted   thanks Joe K  use DESCRIBE FORMATTED  lt table gt  to show table information   ps  database tablename is not supported here

[hive] I have created a table in hive, I would like to know which directory my table is created in?

Examples related to hive

Examples related to hiveql