hi , I am having trouble connecting to beeline. ... Please help me

[#1]

ERROR: Url i used to connect to beeline is jdbc:hihve2://hostname:10000/default .I am using oracle as my hive metastore database. ojdbc6 jar is downloaded and kept at /usr/hdp/2.../hive/lib.My transport mode is binary.After adding these jars when i am logged in as root i can connect to beeline with my ldap uid and pwd. But when i am logged with user id in linux machine and try to connect to beeline. I am getting the same error again

[#2]

It's a wrong jdbc class name for uri.

Try to use this "beeline jdbc:hive2://hostname:10000/default" instead of.

[#3]

what i usually do is beeline >

!connect jdbc:hive2://hostname:port/default with " " and withh out.I tried both but it did not work.

[#4]

Then, check the hostname which is installed with hiveserver2 on a node.

[#5]

@pv poreddythe connection string you are using from you screen shot is: jdbc:hive2//<servername>:10000 which is missing a colon (:) it is supposed to be jdbc:hive2://<servername>:10000 for more details you can refer to: https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients

[#6]

I have given url correctly. But it doesn't work and still stays the same error

[#7 · Accepted solution]

The above error is more indicative of a corrupted instal of the hive client. You mentioned that you are able to connect with LDAP userid and password. In the case where you are getting the error did you launch the beeline cli from the same machine where you launched when you were successfully able to connect using LDAP credentials?

[#8]

yes @Deepesh,I launched both beeline from the same machine. if there is a corrupted install of hive client, please suggest me a solution as in what steps needs to be taken. Also I am using ambari 2.2.2.0 and hdp 2.4.2... when i click on hive service, I do not see the jdbc url down and also the quick links option. Thanks

[#9]

I am assuming this is an unsecure cluster, is that right?

On that machine, can you put out the complete console log from the terminal and i would suggest just starting the beeline and then put the connect statment:

$ beeline
...
> !connect jdbc:hive2://<hivehost>:10000 <user> <pwd>

[#10]

I do not know what went wrong but i removed the hive client and installed it again and it worked this time. Thanks