Hive雷坑记录

1. 元数据库MYSQL初始化时报错（但之前已经把mysql的jar包拷到hive的lib目录下了）

.org.apache.hadoop.hive.metastore.HiveMetaException: Failed to load driver

解决方案：

重新下载了最新版的jar包mysql-connector-java-5.1.45.tar.gz (之前是5.1.42），复制到hive的lib目录下

2. 复制了新的jar包，初始化时仍报错

org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version.
Underlying cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException : Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
SQL Error code: 0
Use --verbose for detailed stacktrace.
*** schemaTool failed ***

解决方案：

把conf目录下的hive-site.xml文件中改成了
<property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://