TSocket读取0字节(代码THRIFTTRANSPORT):TTransportException('TSocket读取0字节',)

[在此处输入图片描述] [1]当我将HIVE集成到我的HUE中时,我报告了一个错误。

我尝试了很多天,但无法解决。谁能帮我吗?

我在Google上搜索,但没有成功。

tsocket read 0 bytes
×
tsocket read 0 bytes (code THRIFTTRANSPORT): TTransportException('tsocket read 0 bytes',)

更新: 我的色相版本是4.5.0,而蜂巢版本是3.1.0

配置单元是hdp 3.1.4.0的组件之一

并且没有配置kerberos

与hue conf相关的配置单元如下:

[beeswax]

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

 hive_server_host=jd-xxx-001.ABC.XYZ

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

 # 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

色相日志如下:     

[03/Nov/2019 19:12:43 -0800] access       INFO     192.168.16.13 admin - "GET /static/desktop/js/queryBuilder.4597d86a7a3f.js HTTP/1.1" returned in 3ms
    [03/Nov/2019 19:12:43 -0800] access       INFO     192.168.16.13 admin - "GET /static/desktop/js/bundles/hue/notebook-chunk-8a9143f5572b79c918e5.aefcf25c309b.js HTTP/1.1" returned in 1ms
    [03/Nov/2019 19:12:43 -0800] access       INFO     192.168.16.13 admin - "GET /static/desktop/js/bundles/hue/vendors~notebook-chunk-8a9143f5572b79c918e5.8b3cae4709a3.js HTTP/1.1" returne
d in 3ms
    [03/Nov/2019 19:12:44 -0800] hive_server2_lib INFO     Opening beeswax thrift session for user admin
    [03/Nov/2019 19:12:44 -0800] thrift_util  INFO     Thrift exception; retrying: tsocket read 0 bytes
    [03/Nov/2019 19:12:44 -0800] thrift_util  INFO     Thrift exception; retrying: tsocket read 0 bytes
    [03/Nov/2019 19:12:44 -0800] thrift_util  WARNING  Out of retries for thrift call: OpenSession
    [03/Nov/2019 19:12:44 -0800] thrift_util  INFO     Thrift saw a transport exception: tsocket read 0 bytes
    [03/Nov/2019 19:12:44 -0800] access       INFO     192.168.16.13 admin - "POST /notebook/api/autocomplete/ HTTP/1.1" returned in 33ms
    [03/Nov/2019 19:12:44 -0800] access       INFO     192.168.16.13 admin - "POST /notebook/api/create_notebook HTTP/1.1" returned in 5ms
    [03/Nov/2019 19:12:44 -0800] access       INFO     192.168.16.13 admin - "GET /desktop/workers/aceSqlSyntaxWorker.js HTTP/1.1" returned in 3ms
    [03/Nov/2019 19:12:44 -0800] access       INFO     192.168.16.13 admin - "GET /desktop/workers/aceSqlLocationWorker.js HTTP/1.1" returned in 1ms
    [03/Nov/2019 19:12:44 -0800] access       INFO     192.168.16.13 admin - "GET /desktop/api2/user_preferences/default_app HTTP/1.1" returned in 2ms
    [03/Nov/2019 19:12:44 -0800] access       INFO     192.168.16.13 admin - "GET /static/desktop/js/ace/theme-hue.js HTTP/1.1" returned in 0ms
    [03/Nov/2019 19:12:45 -0800] access       WARNING  192.168.16.13 admin - "POST /jobbrowser/jobs/ HTTP/1.1"-- 404 not found
    [03/Nov/2019 19:12:45 -0800] base         WARNING  Not Found: /jobbrowser/jobs/
    [03/Nov/2019 19:12:45 -0800] access       INFO     192.168.16.13 admin - "GET /notebook/api/get_history HTTP/1.1" returned in 5ms
    [03/Nov/2019 19:12:45 -0800] access       INFO     192.168.16.13 admin - "GET /static/desktop/js/ace/snippets/hive.js HTTP/1.1" returned in 0ms
    [03/Nov/2019 19:12:45 -0800] access       INFO     192.168.16.13 admin - "GET /desktop/api2/context/computes/hive HTTP/1.1" returned in 19ms
    [03/Nov/2019 19:12:46 -0800] hive_server2_lib INFO     Opening beeswax thrift session for user admin
    [03/Nov/2019 19:12:46 -0800] thrift_util  INFO     Thrift exception; retrying: tsocket read 0 bytes
    [03/Nov/2019 19:12:46 -0800] thrift_util  INFO     Thrift exception; retrying: tsocket read 0 bytes
    [03/Nov/2019 19:12:46 -0800] thrift_util  WARNING  Out of retries for thrift call: OpenSession
[03/Nov/2019 19:12:46 -0800] thrift_util INFO Thrift saw a transport exception: tsocket read 0 bytes [03/Nov/2019 19:12:46 -0800] decorators ERROR Error running create_session Traceback (most recent call last): File "/home/hue/hue450_install/hue/desktop/libs/notebook/src/notebook/decorators.py",line 105,in decorator return func(*args,**kwargs) File "/home/hue/hue450_install/hue/desktop/libs/notebook/src/notebook/api.py",line 97,in create_session response['session'] = get_api(request,session).create_session(lang=session['type'],properties=properties) File "/home/hue/hue450_install/hue/desktop/libs/notebook/src/notebook/connectors/hiveserver2.py",line 90,in decorator raise QueryError(message) QueryError: tsocket read 0 bytes (code THRIFTTRANSPORT): TTransportException('tsocket read 0 bytes',)

fish890129 回答:TSocket读取0字节(代码THRIFTTRANSPORT):TTransportException('TSocket读取0字节',)

类似的声音解释了为什么https://github.com/cloudera/hue/issues/849

,

这对我有帮助

  1. hue/build/env/bin/pip install thrift-sasl==0.2.1
  2. 使用SASL框架建立与主机的连接。 use_sasl=true
  3. engine=sqlite3-> engine=postgresql_psycopg2(或另一个数据库)
本文链接:https://www.f2er.com/3169250.html

大家都在问