https://community.cloudera.com/t5/Support-Questions/Beeline-u-quot-JDBC-hive2-url-quot-n-username-gives-error/m-p/176873#M139123 <P><A rel="user" href="https://community.cloudera.com/users/11386/gauravmallik12.html" nodeid="11386">@Gaurav Mallikarjuna</A></P><P>I tested the same as mine HDP 2.6.1 and could not see any issues</P><PRE>[root@dkhdp262c6 ~]# beeline -u "jdbc:hive2://dkhdp263c6.openstacklocal:2181,dkhdp262c6.openstacklocal:2181,dkhdp261c6.openstacklocal:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" -n admin Connecting to jdbc:hive2://dkhdp263c6.openstacklocal:2181,dkhdp262c6.openstacklocal:2181,dkhdp261c6.openstacklocal:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 Connected to: Apache Hive (version 1.2.1000.2.6.1.0-129) Driver: Hive JDBC (version 1.2.1000.2.6.1.0-129) Transaction isolation: TRANSACTION_REPEATABLE_READ Beeline version 1.2.1000.2.6.1.0-129 by Apache Hive 0: jdbc:hive2://dkhdp263c6.openstacklocal:218&gt; show databases; +----------------+--+ | database_name | +----------------+--+ | default | +----------------+--+ 1 row selected (0.305 seconds) 0: jdbc:hive2://dkhdp263c6.openstacklocal:218&gt; </PRE><P>This is non Kerberised environment though. </P><P>One more thing, I have transport mode set to <STRONG><EM>binary</EM></STRONG>. What is yours?</P><P>If your environment is also non-Kerberised and hive transport mode is <STRONG><EM>binary</EM></STRONG>, try the following:</P><PRE>beeline -u "jdbc:hive2://dkhdp261c6.openstacklocal:10000/" -n admin</PRE><P>The above is a hostname where your hiveserver2 is installed + its port number. </P><P>Here is how this works my end:</P><PRE>[root@dkhdp262c6 ~]# beeline -u "jdbc:hive2://dkhdp261c6.openstacklocal:10000/" -n admin Connecting to jdbc:hive2://dkhdp261c6.openstacklocal:10000/ Connected to: Apache Hive (version 1.2.1000.2.6.1.0-129) Driver: Hive JDBC (version 1.2.1000.2.6.1.0-129) Transaction isolation: TRANSACTION_REPEATABLE_READ Beeline version 1.2.1000.2.6.1.0-129 by Apache Hive 0: jdbc:hive2://dkhdp261c6.openstacklocal:100&gt; show databases; +----------------+--+ | database_name | +----------------+--+ | default | +----------------+--+ 1 row selected (0.29 seconds) 0: jdbc:hive2://dkhdp261c6.openstacklocal:100&gt; </PRE> Mon, 10 Jul 2017 17:46:00 GMT dkozlowski 2017-07-10T17:46:00Z