无法访问用配置单元创建的数据库并在其上运行查询

0aydgbwb  于 2021-06-01  发布在  Hadoop
关注(0)|答案(0)|浏览(210)

我想使用色调作为一个可视化界面的配置单元,服务器hiveserver2启动良好,我可以在命令没有问题。
我的hadoop也是功能性的(在localhost上运行的单节点),我成功地为hue配置了hdfs文件,并且我可以使用hue接口轻松地查看hdfs文件。但我这几周的最大问题是用hue发出一个Hive请求(即使我是根据我在互联网上找到的研究来配置的)。我做不到,就被卡住了
你的帮助将不胜感激。
这是hive-site.xml

<?xml version="1.0"?>

-<configuration>

-<property>

<name>hive.exec.local.scratchdir</name>

<value>/tmp/hive_temp</value>

<description>Local scratch space for Hive jobs</description>

</property>

-<property>

<name>hive.execution.engine</name>

<value>mr</value>

<description> Expects one of [mr, tez, spark]. Chooses execution engine. Options are: mr (Map reduce, default)</description>

</property>

-<property>

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

<value>jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=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>Driver class name for a JDBC metastore</description>

</property>

-<property>

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

<value>hive</value>

<description>Username to use against metastore database</description>

</property>

-<property>

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

<value>hivepassword</value>

<description>password to use against metastore database</description>

</property>

-<property>

<name>hive.exec.scratchdir</name>

<value>/tmp/hive_tmp</value>

<description>HDFS root scratch dir for Hive jobs which gets created with write all (733) permission</description>

</property>

-<property>

<name>hive.exec.scratchdir</name>

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

<description>HDFS root scratch dir for Hive jobs which gets created with write all (733) permission</description>

</property>

</configuration>

以及hue pseudo-distributed.ini中的配置单元


# Host where HiveServer2 is running.

  # If Kerberos security is enabled, use fully-qualified domain name (FQDN).
   hive_server_host=localhost

  # Port where HiveServer2 Thrift server runs on.
  hive_server_port=10002

  # Hive configuration directory, where hive-site.xml is located
  hive_conf_dir=/usr/local/hive/conf

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题