IDEA 中 用spark 1.6.x 实现 不同数据源join (hive join MySQL )

hive 服务端配置 

[hadoop@node1 conf]$ pwd

/home/hadoop/app/hive-1.1.0-cdh5.7.0/conf

[hadoop@node1 conf]$ cat hive-site.xml 

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>

<configuration>

<property>

  <name>javax.jdo.option.ConnectionURL</name>

  <value>jdbc:mysql://192.168.137.251:3306/hive?createDatabaseIfNotExist=true</value>

  <description>JDBC connect string for a JDBC metastore</description>

</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>

<property>

  <name>hive.metastore.warehouse.dir</name>

  <value>/user/hive/warehouse</value>

</property>

<property>

    <name>hive.cli.print.current.db</name>

    <value>true</value>

  </property>

   <property>

    <name>hive.cli.print.header</name>

    <value>true</value>

   </property>

<property>

<name>hive.server2.thrift.port</name>

   <value>10000</value>