在ubuntu14.04环境下搭建hive-0.12.0 64位系统

1.安装mysql

sudo apt-get install mysql-server

sudo apt-get install mysql-client

注意：设置用户密码

进入mysql

mysql -u root -p

更改用户密码：

mysql admin -u root -p password

2.配置hive

1)配置

cd /hive-0.12-0/conf

cp hive-default.xml.template hive-site.xml

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://localhost:3306/hive_DB?createDatabaseIfNotExist=true</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>root</value>
  <description>username to use against metastore database</description>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>123456</value>
  <description>password to use against metastore database</description>
</property>

2)启动

cd /hive-0.12-0/bin/

./hive

3.在debug方式下启动hive

./hive -hiveconf hive.root.logger=DEBUG,console