用beeline连接SparkSQL

mime

⽤beeline连接SparkSQL

1. 在$SPARK_HOME/l⽂件中添加下⾯的属性

vi $SPARK_HOME/l

<name&astore.uris</name>常芝青>葫芦岛市商业银行

<value>thrift://master:9083</value>

<description>Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.

</description>

</property>

<name>hive.server2.thrift.bind.host</name>

<description>Bind host on which to run the HiveServer2 Thrift service.</description>

</property>

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

<description>Port number of HiveServer2 Thrift interface when de is 'binary'.</description> </property>

<name>hive.server2.thrift.min.worker.threads</name>

<description>Minimum number of Thrift worker threads</description>

对甲苯磺酸甲酯

</property>

<name>hive.server2.thrift.max.worker.threads</name>

<description>Maximum number of Thrift worker threads</description>

</property>

<value>false</value>

</property>

</configuration>

2. 复制mysql JDBC驱动⽂件到$SPARK_HOME/lib/

cp mysql-connector-java-5.1.31-bin.jar $SPARK_HOME/lib/

3. 启动hive元数据存储服务

南方电视台少儿频道hive --service metastore > /tmp/grid/hive_metastore.log 2>&1 &

华夏之声4. 启动spark thriftserver服务

$SPARK_HOME/sbin/start-thriftserver.sh --master spark://192.168.56.101:7077 --executor-memory 30g

5. 登⼊beeline

$SPARK_HOME/bin/beeline -u jdbc:hive2://192.168.56.101:10001/

参考：

本文发布于:2024-09-22 01:15:15，感谢您对本站的认可！

标签：服务添加葫芦岛市

留言与评论（共有 0 条评论）