Support Questions

Find answers, ask questions, and share your expertise

Hive Database connection in nodejs

avatar
New Contributor

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

2 REPLIES 2

avatar
Expert Contributor

@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 

Thanks,
Satz

avatar
New Contributor

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);
});