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

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

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

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

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

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

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

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

DESCRIBE FORMATTED my table   or  DESCRIBE FORMATTED 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

[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