question When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181) in Support Questions https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177328#M139578 <P>When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181). Why is this / what am I doing wrong?</P> Mon, 10 Jul 2017 11:14:30 GMT gkeys 2017-07-10T11:14:30Z When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181) https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177328#M139578 <P>When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181). Why is this / what am I doing wrong?</P> Mon, 10 Jul 2017 11:14:30 GMT https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177328#M139578 gkeys 2017-07-10T11:14:30Z Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181) https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177329#M139579 <P>weird, could you please post both the url?</P> Mon, 10 Jul 2017 11:44:10 GMT https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177329#M139579 rajkumar_singh 2017-07-10T11:44:10Z Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181) https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177330#M139580 <P><A rel="user" href="https://community.cloudera.com/users/11288/gkeys.html" nodeid="11288">@Greg Keys</A>: The difference between LLAP and Hiveserver2 JDBC URL will be in zooKeeperNamespace. For LLAP the zookeeper namesepace would be hiveserver2-hive2 where as for hiveserver2 the zooKeeperNamespace=hiveserver2. Can you check the same?</P> Mon, 10 Jul 2017 11:47:06 GMT https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177330#M139580 vasubramanian 2017-07-10T11:47:06Z Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181) https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177331#M139581 <P>Thank you <A rel="user" href="https://community.cloudera.com/users/14247/vasubramanian.html" nodeid="14247">@Vani</A>, you are correct, the zookeeper namespace distinguishes the URLs (which is not visible from Ambari UI until you copy-paste somewhere)</P><P>Do you know if this is different for TP (HDP 2.5) vs GA (HDP 2.6) Hive LLAP? I seem to remember the ports being different.</P> Mon, 10 Jul 2017 22:07:22 GMT https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177331#M139581 gkeys 2017-07-10T22:07:22Z Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181) https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177332#M139582 <P>I recall now the port differences ... it is between HiveServer2 (10000) and HiveServer2 Interactive (10500) and nothing with jdbc</P> Tue, 11 Jul 2017 01:04:08 GMT https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177332#M139582 gkeys 2017-07-11T01:04:08Z Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181) https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177333#M139583 <A rel="user" href="https://community.cloudera.com/users/11288/gkeys.html" nodeid="11288">@Greg Keys</A><P>Yes. You are right. The JDBC URL for LLAP is same in HDP 2.5 and 2.6. And yes Hiveserver2 port is 10000 and LLAP port is 10500</P> Tue, 11 Jul 2017 11:58:08 GMT https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177333#M139583 vasubramanian 2017-07-11T11:58:08Z Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181) https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177334#M139584 <P><A rel="user" href="https://community.cloudera.com/users/14247/vasubramanian.html" nodeid="14247">@Vani</A> Is it possible to make LLAP the default namespace? I want to use a JDBC URL without the zooKeeperNamespace parameter.</P> Wed, 04 Apr 2018 18:46:01 GMT https://community.cloudera.com/t5/Support-Questions/When-I-implement-Hive-LLAP-the-JDBC-URLS-are-identical-for/m-p/177334#M139584 hugo_almeida 2018-04-04T18:46:01Z