2.Hive link MySQL

1. installing MySQL See
   

   http://zhangyanfeng.blog.51cto.com/3884312/1733463

2. Create a Hive-site.xml in the Conf file in hive and write to the hive link MySQL configuration information

   
   

<CONFIGURATION><PROPERTY><NAME>JAVAX.JDO.OPTION.CONNECTIONURL</NAME><VALUE>JDBC: Mysql://192.168.0.207: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>root </value></property><property><name>javax.jdo.option.ConnectionPassword</name> <value>root</value></property></configuration>

3. Testing

/bin/below execution

./hive

After landing

Time show databases; see if the link is on

This article from "in order to finger that direction" blog, declined reprint!

2.Hive link MySQL