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

To see the structure of table (using create statement)-

show create table table_name;

Answer 2

DESCRIBE FORMATTED <tablename>

or

DESCRIBE EXTENDED <tablename>

I prefer formatted because it is more human readable format

Answer 3

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 <table> to show table information.

ps: database.tablename is not supported here.

Answer 4

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.

Answer 5

Further to pensz answer you can get more info using:

DESCRIBE EXTENDED my_table;

or

DESCRIBE EXTENDED my_table PARTITION (my_column='my_value');

Answer 6

DESCRIBE FORMATTED my_table;

or

DESCRIBE FORMATTED my_table PARTITION (my_column='my_value');