Hadoop Hive Database

I’m new to Hadoop Hive, now i’m connecting Hive PHP using Apache thrift, its working good. I want to know where is the Hadoop Hive Database file store in server ? (Database file path). Can anybody please help me, i want to transfer my tables to another server.


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

In Hive, tables are actually stored in a few places. Specifically, if you use partitions (which you should, if your tables are very large or growing) then each partition can have its own storage.

To show the default location where table data or partitions will be created if you create them through default HIVE commands: (insert overwrite … partition … and such):

describe formatted dbname.tablename To show the actual location of a particular partition within a HIVE table, instead do this:

describe formatted dbname.tablename partition (name=value) If you look in your filesystem where a table “should” live, and you find no files there, it’s very likely that the table is created (usually incrementally) by creating a new partition and pointing that partition at some other location. This is a great way of building tables from things like daily imports from third parties and such, which avoids having to copy the files around or storing them more than once in different places.


Hive normally stores your tables in HDFS filesystem for Hadoop. Also, there is a metastore in hive which stores you schema for your tables by default it make use of derby database. As I am not sure of your cluster configuration it will be difficult to answer your query. But, all these path you can find inside your “hive-site.xml” file present in “/etc/hive/conf”.

Kindly, let me know if this answers your query or if you are looking for more details on it.

Regards, Sandeep

If you have any doubt related to hadoop contact jpa solutions