使用sparkSq来访问hive:
sparkSql是建立在hive之上的,使用sparksql来访问hive需要在conf文件夹下配置hive-site.xml文件,该文件配置了hive中metastore相关的原数据信息
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/sparksql?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>lc</value>
<