question Hive Database connection in nodejs in Support Questions

Hive Database connection in nodejs

Arun0811 — Mon, 18 Nov 2024 08:08:29 GMT

Iam trying to connect hive database using hive-driver npm package in nodejs. But the session can't be established. If anyone please help me on this

Re: Hive Database connection in nodejs

satz — Mon, 18 Nov 2024 13:47:18 GMT

@Arun0811 Thank you for posting your query with us, I believe you are trying to use Hive with NodeJS application using Hive-Driver https://www.npmjs.com/package/hive-driver and it fails

Could you share us the ERROR message which you are receiving while connecting the same

Along with the configuration samples which you are trying

Re: Hive Database connection in nodejs

Arun0811 — Tue, 19 Nov 2024 05:37:44 GMT

Hi @satz ,

this is my code,Here I put log for both client and session variable.The client variable returns circular json response and session variable does not return anything.so please help me on this.

const hive = require('hive-driver');
const { TCLIService, TCLIService_types } = hive.thrift;
const client = new hive.HiveClient(
TCLIService,
TCLIService_types
);

client.connect(
{
host : "xxxxx" ,
port : "xxx",
database: "xxxx",
username :"xxxx",

password: "xxxxx",
},
new hive.connections.TcpConnection(),
new hive.auth.NoSaslAuthentication()
).then(async client => {
console.log('client',client);
const session = await client.openSession({
client_protocol: TCLIService_types.TProtocolVersion.HIVE_CLI_SERVICE_PROTOCOL_V10
});

console.log('session',session);
const response = await session.getInfo(
TCLIService_types.TGetInfoType.CLI_DBMS_VER
);

console.log(response.getValue());

await session.close();
}).catch(error => {
console.log(error);
});