Member since
03-09-2017
7
Posts
1
Kudos Received
0
Solutions
03-20-2017
08:07 AM
I find that the temporary solution is restart the hiveserver2 service frequently. Post the full beeswax configuration section of hue.ini. ###########################################################################
# Settings to configure Beeswax
###########################################################################
[beeswax]
# Host where Hive server Thrift daemon 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=10000
# Hive configuration directory, where hive-site.xml is located
## hive_conf_dir=/etc/hive/conf
hive_conf_dir=/etc/hive/conf
# Timeout in seconds for thrift calls to Hive service
## server_conn_timeout=120
server_conn_timeout=300
# Set a LIMIT clause when browsing a partitioned table.
# A positive value will be set as the LIMIT. If 0 or negative, do not set any limit.
## browse_partitioned_table_limit=250
# A limit to the number of rows that can be downloaded from a query.
# A value of -1 means there will be no limit.
# A maximum of 65,000 is applied to XLS downloads.
## download_row_limit=1000000
# 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
# Option to show execution engine choice.
## show_execution_engine=False
# "Go to column pop up on query result page. Set to false to disable"
## go_to_column=true
[[ssl]]
# SSL communication enabled for this server.
## enabled=false
# Path to Certificate Authority certificates.
## cacerts=/etc/hue/cacerts.pem
# Path to the private key file.
## key=/etc/hue/key.pem
# Path to the public certificate file.
## cert=/etc/hue/cert.pem
# Choose whether Hue should validate certificates received from the server.
## validate=true
... View more
03-16-2017
10:12 AM
Hi Juan, the attachement is the whole hue's configurations: hue.txt
... View more
03-09-2017
03:12 PM
add the platform and tools information: Red Hat Enterprise Linux Server release 6.3 (Santiago) gcc (GCC) 4.4.6 20120305 (Red Hat 4.4.6-4) java version "1.8.0_71"
Java(TM) SE Runtime Environment (build 1.8.0_71-b15)
Java HotSpot(TM) 64-Bit Server VM (build 25.71-b15, mixed mode)
... View more
03-09-2017
11:50 AM
Anybody encoutered the same problem?
... View more
03-09-2017
11:29 AM
1 Kudo
Hi, everybody I think i encountered one messy problem. After installing the hadoop,hive,hue, etc. services successfully and using hue without any problem for a while, I encountered such one problem. it printed the timeout error when i tried to login in to the beeswax page. I have tried some ways including installing the hiveserver2 service and hue server service in the same host, changing the value of hive_server_host from fqdn to localhost, changing the server_conn_timeout from 120 to 300 of hue.ini, etc. But all these ways didn't work. I think maybe i should read the source code of hue and hive, and then trace it. Maybe you guys have solutions, do you? Thanks in advance. Versions of HDP and hue, hive: HDP: 2.5.0.0 hue: 2.6.1.2.5.0.0 hive: 1.2.1000 Parts of the logs of hivesever2 in both cases: 1. successfully login from hue ui see the text file or png file. success-hiveserver2.txt 2. failed to login from hue ui, or timeout error see the text file or png file. fail-hiveserver2.txt Parts of the logs of hue in fail case: see the text file. fail-hue.txt Please use vim or other editor open the text file because of the aligning problem. Ignoring the time in the log, maybe it's a bug of hue, or maybe no. Buy the way, some of the configuration options of hive like this: hive.server2.enable.doAs=true hive.server2.authentication=NOSASL
... View more
Labels:
- Labels:
-
Apache Hive
-
Cloudera Hue