Support Questions

Find answers, ask questions, and share your expertise

How to connect to Hive HA cluster from beeline?

avatar

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

http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.4.2/bk_hadoop-ha/content/ha-hs2-service-discover...

Command used looks like

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

Thanks,

1 ACCEPTED SOLUTION

avatar
Master Collaborator

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

View solution in original post

2 REPLIES 2

avatar
Master Collaborator

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

avatar

Thanks Qi, adding quotes solved the problem.