question Re: How to connect to Hive HA cluster from beeline? in Archives of Support Questions (Read Only)

How to connect to Hive HA cluster from beeline?

__anonymous__ — Thu, 19 May 2016 04:27:00 GMT

I setup Hive HA by installing 2 HiveServer2 to the cluster. But could not connect to the cluster with beeline following the document instruction from

Command used looks like

beeline -u jdbc:hive2://zk01:2181,zk02:2181,zk03:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 -n hive -p hadoop

Thanks,

qiwang — Thu, 19 May 2016 04:29:23 GMT

When using beeline, you need to put the connection string in double quote. The following command should work for you

beeline -u "jdbc:hive2://zk01:2181,zk02:2181,zk03:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" -n hive -p hadoop

please let me know if that solves you problem.

-Qi

__anonymous__ — Thu, 19 May 2016 04:31:18 GMT

Thanks Qi, adding quotes solved the problem.