Hadoop Hive Database

Posted January 25, 2018 4.2k views
ApacheBig Data

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.

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.

Submit an Answer
3 answers

If you have any doubt related to hadoop contact jpa solutions


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.


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.