1

I created a managed table without specifying the location where data will be stored.I thought it will be in the user/hive/warehouse/ dir but the data is not there.When I did select * data is seen in the table.

So where is the data location in this scenario.Is it in the temp dir.

Vivek
  • 31
  • 4
  • This will be useful to you: [hive warehouse location](http://stackoverflow.com/questions/5058400/where-does-hive-store-its-files-in-hdfs) – ozw1z5rd Oct 15 '16 at 21:48

1 Answers1

1

Go to hive shell and fire:

 SHOW CREATE TABLE table_name

You will see location in the output.

It should be your 

hive_warehouse_directory/database_name.db/table_name
Dev
  • 13,492
  • 19
  • 81
  • 174