我通过以下教程安装了hadoop和hive:https://phoenixnap.com/kb/install-hadoop-ubuntuhttpshttp://phoenixnap.com/kb/install-hive-on-ubuntuhttps://medium.com/analytics-vidhya/hive-installation-on-ubuntu-18-04-b3362dcadfb8
我的hive-site.xml配置为:
<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true&autoReconnect=true&useSSL=false</value>
<description>metadata is stored in a MySQL server</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>MySQL JDBC driver class</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hiveuser</value>
<description>user name for connecting to mysql server</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>hivepassword</value>
<description>hivepassword for connecting to mysql server</description>
</property>
<name>hive.metastore.uris</name>
<value>thrift://localhost:9083</value>
<description>Thrift URI for the remote metastore.</description>
</property>
</configuration>
我也尝试过将hive.metastore.dir添加到配置单元站点的命令,但它仍然会挂起并且永远不会完成。
我已经能够在ubuntu20.04服务器上连接hive和sparksql,但我的最终目标是能够在我使用的任何一台计算机上连接sparksql到tableau。如果不启动hive--service metastore命令,我将无法做到这一点。
有人知道为什么我的命令挂起了吗?
谢谢您!
暂无答案!
目前还没有任何答案,快来回答吧!