- 配置
hive-site.xml
<configuration>
<property>
<name>hive.metastore.local</name>
<value>true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hive</value>
</property>
</configuration>
- 下載
mysql-connector-java-*.*.jar阴绢，放到lib目錄下姐帚。 - 配置
hive-env.sh济蝉，添加
HADOOP_HOME=/opt/soft/hadoop/hadoop
export HIVE_CONF_DIR=/opt/hive/conf
- 初始化數(shù)據(jù)庫
./schematool -initSchema -dbType mysql
