TSocket membaca 0 byte (kode THRIFTTRANSPORT): TTransportException('TSocket membaca 0 byte',)

[masukkan deskripsi gambar di sini] [1] Saat saya mengintegrasikan HIVE ke dalam HUE saya, saya melaporkan kesalahan.

Saya mencoba selama berhari-hari, tetapi saya tidak dapat menyelesaikannya. Ada yang bisa bantu saya?

Saya mencari di Google, tetapi tidak berhasil.

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

pembaruan: versi rona saya adalah 4.5.0 dan versi Hive adalah 3.1.0

Hive adalah salah satu komponen hdp 3.1.4.0

dan tidak ada kerberos yang dikonfigurasi

sarang terkait hue conf ada di bawah:

[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

hue log as below:

[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',)


person WakerWang    schedule 04.11.2019    source sumber
comment
Saya tidak tahu cara mengunggah gambar.   -  person WakerWang    schedule 04.11.2019
comment
Selamat datang di JADI! Saat Anda mengajukan pertanyaan, cobalah menambahkan konten minimum: sampel masukan, sampel keluaran yang diharapkan, apa yang Anda coba, riset, dan di mana Anda terjebak. Kami memerlukan informasi lebih lanjut. Untuk menambahkan satu gambar saja, edit postingan Anda (pilih edit di bagian bawah postingan Anda) dan, di bilah edisi, di bagian atas kode postingan Anda, Anda akan menemukan satu Ikon untuk mengunggah gambar. Klik di atasnya, maka satu add-in kecil akan meminta Anda untuk menjelajah di komputer Anda, cukup pilih gambar Anda dan selesai. Ketika upload selesai, pada kode tersebut Anda dapat menambahkan deskripsi.   -  person David García Bodego    schedule 04.11.2019
comment
Terima kasih. Saya telah mengunggah gambar saya. Dan ini adalah konfigurasi hue.ini saya   -  person WakerWang    schedule 04.11.2019
comment
Saya mohon maaf atas uraian saya. Karena ini pertama kalinya saya menggunakan stack overflow.   -  person WakerWang    schedule 04.11.2019


Jawaban (2)


Ini membantu saya:

  1. hue/build/env/bin/pip install thrift-sasl==0.2.1
  2. Gunakan kerangka SASL untuk membuat koneksi ke host. use_sasl=true
  3. engine=sqlite3 -> engine=postgresql_psycopg2 (atau db lain)
person Str787    schedule 29.11.2019

Kedengarannya sama dengan yang satu ini yang menjelaskan alasannya https://github.com/cloudera/hue/issues/849

person Romain    schedule 05.11.2019