Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181)

Solved Go to solution
Highlighted

When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181)

Guru

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181)

Contributor

@Greg Keys: 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?

View solution in original post

6 REPLIES 6
Highlighted

Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181)

weird, could you please post both the url?

Highlighted

Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181)

Contributor

@Greg Keys: 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?

View solution in original post

Highlighted

Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181)

Guru

Thank you @Vani, you are correct, the zookeeper namespace distinguishes the URLs (which is not visible from Ambari UI until you copy-paste somewhere)

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.

Highlighted

Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181)

Guru

I recall now the port differences ... it is between HiveServer2 (10000) and HiveServer2 Interactive (10500) and nothing with jdbc

Highlighted

Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181)

Contributor
@Greg Keys

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

Re: When I implement Hive LLAP the JDBC URLS are identical for HiveServer2 and HiveServer2 interactive (both have port 2181)

@Vani Is it possible to make LLAP the default namespace? I want to use a JDBC URL without the zooKeeperNamespace parameter.

Don't have an account?
Coming from Hortonworks? Activate your account here