Hadoop Hive Database

January 25, 2018 2.1k views
Apache Big 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.

3 Answers

If you have any doubt related to hadoop contact jpa solutions

Hello,

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

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.

Have another answer? Share your knowledge.