hive - Web HUE 安装和设置完成。但是仪表板不工作
问题描述
我最近在我的 hadoop 集群上设置了 Hue,一切看起来都很好。我能够打开 webhue,即 localhost:8888,我可以看到 HDFS、HBase 和 Mysql。但我在这方面仍然面临一些问题。任何人都可以在这方面帮助我。面临的问题是: Hive 连接:我正在使用直线,并且我能够在 shelll 上使用直线连接到配置单元数据库但是在 web 色调中,它显示错误加载数据库。我在 hue.ini 文件中使用的配置是
hive_server_host=localhost
HiveServer2 Thrift 服务器运行的端口。
hive_server_port=10000
第二个问题是即使我能够连接到 mysql 数据库,我面临的问题是在仪表板选项卡中。我可以看到所有小部件和图表选项,例如饼图、条形图等。但是当我将它们拖放到页面上时,它会永远加载。我看不到表格数据的任何图表。
请帮助我,因为我已经尝试了 10 天,但我还找不到任何指针。
解决方案
@Ruthikajawar 我在这里有一个工作的hue.ini:
https://github.com/steven-dfheinz/HDP3-Hue-Service/blob/Hue.4.6.0/configuration/live.hue.ini
工作蜂巢的具体细节是:
[beeswax]
# Host where HiveServer2 is running.
# If Kerberos security is enabled, use fully-qualified domain name (FQDN).
hive_server_host=hdp.cloudera.com
# Binary thrift port for HiveServer2.
#hive_server_port=10000
# Http thrift port for HiveServer2.
#hive_server_http_port=10001
# Host where LLAP is running
## llap_server_host = localhost
# LLAP binary thrift port
## llap_server_port = 10500
# LLAP HTTP Thrift port
## llap_server_thrift_port = 10501
# Alternatively, use Service Discovery for LLAP (Hive Server Interactive) and/or Hiveserver2, this will override server and thrift port
# Whether to use Service Discovery for LLAP
## hive_discovery_llap = true
# is llap (hive server interactive) running in an HA configuration (more than 1)
# important as the zookeeper structure is different
## hive_discovery_llap_ha = false
# Shortcuts to finding LLAP znode Key
# Non-HA - hiveserver-interactive-site - hive.server2.zookeeper.namespace ex hive2 = /hive2
# HA-NonKerberized - (llap_app_name)_llap ex app name llap0 = /llap0_llap
# HA-Kerberized - (llap_app_name)_llap-sasl ex app name llap0 = /llap0_llap-sasl
## hive_discovery_llap_znode = /hiveserver2-hive2
# Whether to use Service Discovery for HiveServer2
hive_discovery_hs2 = true
# Hiveserver2 is hive-site hive.server2.zookeeper.namespace ex hiveserver2 = /hiverserver2
hive_discovery_hiveserver2_znode = /hiveserver2
# Applicable only for LLAP HA
# To keep the load on zookeeper to a minimum
# ---- we cache the LLAP activeEndpoint for the cache_timeout period
# ---- we cache the hiveserver2 endpoint for the length of session
# configurations to set the time between zookeeper checks
## cache_timeout = 60
# Host where Hive Metastore Server (HMS) is running.
# If Kerberos security is enabled, the fully-qualified domain name (FQDN) is required.
#hive_metastore_host=hdp.cloudera.com
# Configure the port the Hive Metastore Server runs on.
#hive_metastore_port=9083
# Hive configuration directory, where hive-site.xml is located
hive_conf_dir=/etc/hive/conf
# Timeout in seconds for thrift calls to Hive service
## server_conn_timeout=120
# Choose whether to use the old GetLog() thrift call from before Hive 0.14 to retrieve the logs.
# If false, use the FetchResults() thrift call from Hive 1.0 or more instead.
## use_get_log_api=false
# Limit the number of partitions that can be listed.
## list_partitions_limit=10000
# The maximum number of partitions that will be included in the SELECT * LIMIT sample query for partitioned tables.
## query_partitions_limit=10
# A limit to the number of rows that can be downloaded from a query before it is truncated.
# A value of -1 means there will be no limit.
## download_row_limit=100000
# A limit to the number of bytes that can be downloaded from a query before it is truncated.
# A value of -1 means there will be no limit.
## download_bytes_limit=-1
# Hue will try to close the Hive query when the user leaves the editor page.
# This will free all the query resources in HiveServer2, but also make its results inaccessible.
## close_queries=false
# Hue will use at most this many HiveServer2 sessions per user at a time.
# For Tez, increase the number to more if you need more than one query at the time, e.g. 2 or 3 (Tez has a maximum of 1 query by session).
## max_number_of_sessions=1
# Thrift version to use when communicating with HiveServer2.
# Version 11 comes with Hive 3.0. If issues, try 7.
thrift_version=11
# A comma-separated list of white-listed Hive configuration properties that users are authorized to set.
## config_whitelist=hive.map.aggr,hive.exec.compress.output,hive.exec.parallel,hive.execution.engine,mapreduce.job.queuename
# Override the default desktop username and password of the hue user used for authentications with other services.
# e.g. Used for LDAP/PAM pass-through authentication.
## auth_username=hive
## auth_password=hive
# Use SASL framework to establish connection to host.
use_sasl=true
对于你问题的第二部分。您应该在使用 UI 捕获和解决任何错误时监视 /var/log/hue/error.log。
推荐阅读
- r - 可以根据 Metafor 包/R 中的类别在漏斗图中对数据点进行着色吗?
- google-analytics - 什么是忽略 GTM 中未定义变量的最佳方法,其中数据不可用。
- image - 如何从内存(iOS)中卸载 react-native 图像?
- node.js - 应用程序帖子不起作用我没有得到输出
- angular - 如何将元素拖到另一个容器?
- java - 使用 slf4j 的 Spring Boot 没有创建日志文件
- android - 有没有可能在工具栏中将标题居中?
- javascript - 在反应原生中单击平面列表项时如何将值传递给模态并显示模态
- ruby-on-rails - 如何使 `link_to` 在 Rails 中正常工作
- php - 如何在 laravel 5.4 中为所有请求和响应设置日志