1> 刚开始尝试初始化cdh hive mysql数据库;
cd [hive 安装目录]
bin/schematool -dbType mysql -initSchema --verbose
发现问题并没有解决;
- 手动修改hive配置文件/etc/hive/conf/hive-site.xml
<configuration>
<property>
<name>hive.metastore.db.type</name>
<value>mysql</value>
<description>元数据库类型指定为使用mysql</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>指定mysql的驱动</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>指定元数据库用户</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>
<description>指定元数据库密码</description>
</property>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://[*************IP***********]:3306/hive?createDatabaseIfNotExist=true</value>
<description>指定mysql连接串</description>
</property>
</configuration>