Hive连接Mysql---FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask.

Hive-site.xml

[html] view plain copy

 

1. <?xml version="1.0"?>  
2. <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>  
3.   
4. <configuration>  
5.     <property>  
6.         <name>javax.jdo.option.ConnectionURL</name>  
7.         <value>jdbc:mysql://192.168.80.149:3306/hive?characterEncoding=UTF-8</value>  
8.     </property>  
9.     <property>  
10.         <name>javax.jdo.option.ConnectionDriverName</name>  
11.         <value>com.mysql.jdbc.Driver</value>  
12.     </property>  
13.     <property>  
14.         <name>javax.jdo.option.ConnectionUserName</name>  
15.         <value>hive</value>  
16.     </property>  
17.     <property>  
18.         <name>javax.jdo.option.ConnectionPassword</name>  
19.         <value>guo</value>  
20.     </property>  
21. </configuration>  

改成本地地址问题解决

[html] view plain copy

 

1. <value>jdbc:mysql://192.168.80.149:3306/hive?characterEncoding=UTF-8</value>  

[html] view plain copy

 

1. <value>jdbc:mysql://127.0.0.1:3306/hive?characterEncoding=UTF-8</value>  

其实就是mysql远程访问权限问题，也可以赋予远程访问权限

[sql] view plain copy

 

1. hadoop@ubuntu:~$ mysql -uroot -pmysql  
2. mysql> CREATE USER 'hive' IDENTIFIED BY 'mysql';  
3. mysql> GRANT ALL PRIVILEGES ON *.* TO 'hive'@'192.168.80.149' WITH GRANT OPTION;  
4. mysql> flush privileges;