<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question Re: Beeline -u &amp;quot;JDBC:hive2://url...&amp;quot; -n username  gives error while beeline  !connect &amp;quot;JDBC:hive2://url...&amp;quot;  works in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/Beeline-u-quot-JDBC-hive2-url-quot-n-username-gives-error/m-p/176875#M139125</link>
    <description>&lt;P&gt;&lt;A rel="user" href="https://community.cloudera.com/users/11386/gauravmallik12.html" nodeid="11386"&gt;@Gaurav Mallikarjuna&lt;/A&gt;&lt;/P&gt;&lt;P&gt;I believe the issue could be with the permissions on the  '/user/hive/'  directory in hdfs. So the user you are passing in your beeline command line should have the proper access to this directory as well. In my case, the '/user/hive/' was owned by 'hive' user and 'hadoop' group.  Also the folder has '755' permissions in my case.&lt;/P&gt;&lt;P&gt;I tried below query and it worked for me:&lt;/P&gt;&lt;P&gt;# beeline -u "jdbc:hive2://&amp;lt;my zookeeper fqdn&amp;gt;:2181,&amp;lt;my zookeeper fqdn&amp;gt;:2181,&amp;lt;my zookeeper fqdn&amp;gt;:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2" -u hrt_qa&lt;/P&gt;&lt;P&gt;Connecting to jdbc:hive2://&amp;lt;my zookeeper fqdn&amp;gt;:2181,&amp;lt;my zookeeper fqdn&amp;gt;:2181,&amp;lt;my zookeeper fqdn&amp;gt;:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2&lt;/P&gt;&lt;P&gt;Connected to: Apache Hive (version 1.2.1000.2.5.0.0-1245)&lt;/P&gt;&lt;P&gt;Driver: Hive JDBC (version 1.2.1000.2.5.0.0-1245)&lt;/P&gt;&lt;P&gt;Transaction isolation: TRANSACTION_REPEATABLE_READ&lt;/P&gt;&lt;P&gt;Beeline version 1.2.1000.2.5.0.0-1245 by Apache Hive&lt;/P&gt;&lt;P&gt;0: jdbc:hive2://&amp;lt;my zookeeper hostname&amp;gt;.o&amp;gt;&lt;/P&gt;&lt;P&gt;So, I think it has nothing to with quotes.&lt;/P&gt;</description>
    <pubDate>Tue, 11 Jul 2017 07:33:20 GMT</pubDate>
    <dc:creator>narendrakumar</dc:creator>
    <dc:date>2017-07-11T07:33:20Z</dc:date>
  </channel>
</rss>

