分布式部署 Spark 2.2.1 集成Hive数据仓库的案例与解读(5)

0: jdbc:hive2://localhost:10000> !quit

Closing: 0: jdbc:hive2://localhost:10000

??

二：Http传输模式启动JDBC/ODBC服务的案例。

Thrift JDBC服务支持通过HTTP传输模式来发送Thrift RPC消息。将HTTP模式的配置设置成系统属性，或修改Conf下的hive-site.xml文件中的属性配置来实现。

1)???????????? 修改Hive框架的hive-site.xml配置。

root@master:/usr/local/apache-hive-1.2.1/conf# vihive-site.xml

……

 

  <property>

   <name>hive.server2.transport.mode</name>

   <value>http</value>

   <description>

      Expects oneof [binary, http].

      Transportmode of HiveServer2.

   </description>

  </property>

 

  <property>

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

   <value>10001</value>

   <description>Port number of HiveServer2 Thrift interface whenhive.server2.transport.mode is 'http'.</description>

  </property>

 

  <property>

   <name>hive.server2.http.endpoint</name>

   <value>cliservice</value>

   <description>Path component of URL endpoint when in HTTPmode.</description>

  </property>

 

2)????????????将Hive修改以后的Conf下的hive-site.xml文件拷贝到$SPARK_HOME/conf目录下。

root@master:/usr/local/apache-hive-1.2.1/conf# cp/usr/local/apache-hive-1.2.1/conf/hive-site.xml 

/usr/local/spark-2.2.1-bin-hadoop2.6/conf/

root@master:/usr/local/apache-hive-1.2.1/conf# ls -ltr /usr/local/spark-2.2.1-bin-hadoop2.6/conf/hive-site.xml

-rw-r--r-- 1 root root 1710 Feb 20 20:40/usr/local/spark-2.2.1-bin-hadoop2.6/conf/hive-site.xml

 

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/jisuanjixue/article-86251-5.html