Personally, the configuration procedure of Hive is much easier than Hbase.
Move to installation folder, copy configuration files
update env var:
Actually this configuration comprise of two parts, first one is call
metastore, in which the data structure and definition stored.
Another is the so called data stored in HDFS.
metastore into RDBMS, here I want to use
setup hive to store metadata into
create related tables in postgresql.
This schema file is under
$HIVE_HOME/scripts, find the one that fit your requirement.
Download the JDBC driver for postgresql and move it into
Now just create folders.
Create directories on HDFS for HIVE.
After the creation of table and the import, now check the HDFS for imported data.
hadoop fs -cat /user/hive/warehouse/t_hive/t_hive.txt
Seems good, Cong!
For further steps, please visit official.