hive-jdbc.version 0.12.0 connection error

[changyuanxu]

[1709022192534]INFO1s:Connectioninstance createdfor x_hive.
ns: "conn-manager"
[1709022192537] ERROR(1s): Connecting error:{"code":-1,"data":("driver":"hive","driveroptions":{}},"name":"TAplicationException"}
ns: "conn-manager"
[1709022192538] ERROR (1s): Open connection error
ns: "conn-manager"
[170902192539] EROR(ext): ERRR: Error opening comectin Reguired field 'client protocol’is unset! Struct:TpensessionReg(client protocol:mull), {"code"-1,"data"
{"driver":"hive","driverOptions":{}}}
ns: "error-handler"
[1709022225323] INFO (ext): Connection explorer changed. Will be updated.
ns: "conn-man:explorer"

[samuelhsin]

I will open this plugin source code to help trace bugs.

[samuelhsin]

protocol failed => maybe you can check the connection from your computer and Hive master host.

[changyuanxu]

Thank you very much for opening up the source code. 1、Resolve database connection issues. sqltools-hive-vscode-extension-main\src\ls\driver.ts // create session const { TCLIService_types } = hiveThrift || {}; const session = await this.connectedHiveClient.openSession({ client_protocol: TCLIService_types.TProtocolVersion.HIVE_CLI_SERVICE_PROTOCOL_V4 }); After modifying to HIVE-CLI-SERVICE-PROTOCOL_V4, it can be connected. 2、Then a second error occurs： Requestconnection/GetChildrenForTreeltemRequest failed with message: Cannot read properties of undefined(reading binaryVal") At 2024-02-27 17:20:18, "samuelhsin" ***@***.***> wrote: protocol failed => maybe you can check the connection from your computer and Hive master host. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>

[samuelhsin]

I upload a version supporting thrift hive driver connection protocol version selector, but it does not work for old version. I use simple SQL 'select 1' to test in old version connection and also get error same as yours. It is a bug of hive-driver.