Access problem in hiveserver2 about omniduct HOT 5 CLOSED

Hi @djKooks,

It looks like you're directing the HiveServer2Client to the SSH port of the remote service, which is almost certainly not what you want to do. Do you have a HiveServer2 instance running?

from omniduct.

@matthewwardrop thanks for reply.
Yes, I'm trying to access hive in remote machine(virtualbox instance). If my usage is wrong, please let me know.

Thanks.

from omniduct.

If the remote machine has a hiveserver2 instance, and the ports associated with the instance are exposed, you can just directly connect to it.

from omniduct.databases.hiveserver2 import HiveServer2Client

hsc = HiveServer2Client(
    host='192.168.56.1',  # IP address of virtual machine 
    port=3623,  # Port of HiveServer2 instance (typically 3623)
    driver='pyhive'  # Recommended over impyla
)

hsc.connect()

If the HiveServer2 instance is not exposed, then you will need to use port-forwarding via SSH.

from omniduct.databases.hiveserver2 import HiveServer2Client
from omniduct.remotes.ssh import SSHClient

remote = SSHClient(
     host='192.168.56.1',  # IP address of virtual machine 
     port=22,  # Port of SSH server
)

hsc = HiveServer2Client(
    host='127.0.0.1',  # IP address of localhost 
    port=3623,  # Port of HiveServer2 instance (typically 3623)
    remote=remote
)

hsc.connect()

Hope that helps.

from omniduct.

@matthewwardrop thanks! I'll check again later and let you know.

from omniduct.

@matthewwardrop sorry for late.
It seems it is problem of hive server connection, because it also causes on other modules such as pyhive or impyla.
I'll reopen it if I found a problem in here.

Thanks.

from omniduct.