question Re: Error while connecting Hive to Hue in Support Questions

Error while connecting Hive to Hue

nysq_sq — Thu, 24 Aug 2023 14:33:18 GMT

while connecting hive to hue

Got below error

TSocket read 0 bytes (code THRIFTTRANSPORT): TTransportException('TSocket read 0 bytes',)

Re: Error while connecting Hive to Hue

DianaTorres — Thu, 24 Aug 2023 17:44:19 GMT

@nysq_sq Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our Hive expert @mszurap who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

Re: Error while connecting Hive to Hue

mszurap — Fri, 25 Aug 2023 12:52:29 GMT

Hi @nysq_sq

The above is not helpful to understand what went wrong.

Can you check the Hue logs (runcpserver.log) and Hive (HiveServer2) logs?

What configurations you've enabled in Hue to connect to Hive? (I assume the "beeswax" section was configured)

Please see the hue.ini reference, what is the meaning of each config entry.

https://github.com/cloudera/hue/blob/master/desktop/conf.dist/hue.ini

Best regards

Miklos

Re: Error while connecting Hive to Hue

nysq_sq — Sun, 27 Aug 2023 12:11:49 GMT

[beeswax]

# Host where HiveServer2 is running.
# If Kerberos security is enabled, use fully-qualified domain name (FQDN).
hive_server_host=xxx.xxx.x.xxx

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

above are the details i gave in hue.ini file

Re: Error while connecting Hive to Hue

mszurap — Mon, 28 Aug 2023 08:02:59 GMT

Is the Kerberos authentication enabled on the cluster? As the above comment suggests, you should use the fully-qualified domain name (FQDN) instead of IP address when Kerberos is enabled.

Also note that the port 10001 should be the HTTP transport mode port. The "hive_server_port" on the other hand is for binary transport, and that should be port 10000 on the HS2. This is also explained in the hue.ini reference quoted before.

# Binary thrift port for HiveServer2.
## hive_server_port=10000

# Http thrift port for HiveServer2.
## hive_server_http_port=10001

So please try the following rather:

hive_server_port=10000

Re: Error while connecting Hive to Hue

nysq_sq — Mon, 28 Aug 2023 10:30:16 GMT

keberos authentication is not enabled
i have hue and hive in same server

[beeswax]

# Host where HiveServer2 is running.
# If Kerberos security is enabled, use fully-qualified domain name (FQDN).
hive_server_host=xxx.xxx.x.xxx

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

i have changed the port
Below i got error
Could not connect to 192.168.1.137:10000

Re: Error while connecting Hive to Hue

mszurap — Mon, 28 Aug 2023 12:53:39 GMT

Check if the HS2 runs on port 10000 or on 10001 ("ps -ef | grep HiveServer2" and with "netstat -tanp | grep <hs2pid>"). If it is running only on HTTP transport mode, then the port 10001 might be the only open port. In that case you need

hive_server_http_port=10001

Re: Error while connecting Hive to Hue

nysq_sq — Mon, 28 Aug 2023 13:32:36 GMT

ps -ef | grep HiveServer2
hadoop 1512 29707 0 09:31 pts/5 00:00:00 grep --color=auto HiveServer2

[hadoop@sgpllab1137 bin]$ netstat -tuln | grep 10001
[hadoop@sgpllab1137 bin]$
either port 10000 nor 10001 port listening

Re: Error while connecting Hive to Hue

nysq_sq — Tue, 29 Aug 2023 11:27:42 GMT

Re: Error while connecting Hive to Hue

mszurap — Tue, 29 Aug 2023 13:11:49 GMT

Based on the above, the HiveServer2 is not runnig. Please verify that it's running before trying to use it through Hue.

How did you verify that the HS2 is running? How do you start it? Have you looked into the HiveServer2 logs?

Re: Error while connecting Hive to Hue

nysq_sq — Tue, 29 Aug 2023 13:23:33 GMT

i have installed hive version-apache-hive-3.1.2-bin

under bin folder we have hiveserver2 so i gave command

hiveserver2 start

where do i find hiveserver2 logs ?

Re: Error while connecting Hive to Hue

nysq_sq — Tue, 29 Aug 2023 14:50:13 GMT

Hive to Hue connection is done but

getting error as Tsocket read 0bytes

Re: Error while connecting Hive to Hue

nysq_sq — Wed, 30 Aug 2023 03:51:48 GMT

Did you get any solution for above error.

Error while connecting Hive to Hue

nysq_sq — Thu, 14 Sep 2023 07:31:14 GMT

keberos authentication is not enabled
i have hue and hive in same server

[beeswax]

# Host where HiveServer2 is running.
# If Kerberos security is enabled, use fully-qualified domain name (FQDN).
hive_server_host=xxx.xxx.x.xxx

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

Databases

(0)

Error loading databases.

text

7
8
9
10
11
12
13
14
15
16
17
18
19
 
 
 
-- Get email survey opt-in values for all customers
SELECT
c.id,
c.name,
c.email_preferences.categories.surveys
FROM customers c;
 
 
 
-- Select customers for a given shipping ZIP Code
SELECT
customers.id,
customers.name
FROM customers
WHERE customers.addresses['shipping'].zip_code = '76710';
 
 
 
-- Compute total amount per order for all customers
 
 
 
 
 

7 days ago

Sample: Customers

-- Get email survey opt-in values for all customers 
SELECT 
c.id, 
c.name, 
c.email_preferences.categories.surveys 
FROM customers c; 
 
 
 
-- Select customers for a given shipping ZIP Code 
SELECT 
customers.id, 
customers.name 
FROM customers 
WHERE customers.addresses['shipping'].zip_code = '76710'; 
 
 
 
-- Compute total amount per order for all customers 
SELECT 
c.id AS customer_id, 
c.name AS customer_name, 
ords.order_id AS order_id, 
SUM(order_items.price * order_items.qty) AS total_amount 
FROM 
customers c 
LATERAL VIEW EXPLODE(c.orders) o AS ords 
LATERAL VIEW EXPLODE(ords.items) i AS order_items 
GROUP BY c.id, c.name, ords.order_id; 

Assistant

Functions

Tables

Statement 1/3

default.customers

Sessions

Hive

Recreate Close

Add a property...FilesFunctionsSettings

i have changed the port and tried but same issue

Could not connect to 192.168.1.137:10000