How to use rbhive gem and query hive

Question

I have a task to query in a hive db from ruby code. I am planning to use rbhive gem, but from it documentation, I am not able to get how to pass username, password, db name, etc when connecting to hive server.

Here is my code:

res = RBHive.connect('host_address', 10_000) do |connection|
  connection.fetch 'show databases;'
end

It just shows:

Connecting to host_server on port 10000
Executing Hive Query: show databases;

and it hangs there indefinitely.

Answer 1

That may be surprising, but with Hive 1.0.0 I managed to connect using

RBHive.tcli_connect('host', 10000, {transport: :sasl, sasl_params:{}}) do |connection|

Answer 2

Please use

options = { username: 'username', password: 'password' }
RBHive.tcli_connect('host', 'port', { transport: :sasl, sasl_params: options}) do |connection|
  results = connection.execute "SHOW DATABASES"
end