question Re: hi , I am having trouble connecting to beeline. ... Please help me in Support Questions

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

pvln_reddy1919 — Sun, 18 Aug 2019 03:57:01 GMT

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

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

MindGlass — Fri, 04 Aug 2017 08:21:12 GMT

It's a wrong jdbc class name for uri.

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

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

pvln_reddy1919 — Fri, 04 Aug 2017 08:45:48 GMT

what i usually do is beeline >

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

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

MindGlass — Fri, 04 Aug 2017 10:47:54 GMT

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

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

dheer_vijji_rag — Fri, 04 Aug 2017 11:07:55 GMT

@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

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

pvln_reddy1919 — Fri, 04 Aug 2017 22:44:16 GMT

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

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

deepesh1 — Fri, 04 Aug 2017 23:14:10 GMT

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?

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

pvln_reddy1919 — Sat, 05 Aug 2017 00:16:44 GMT

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

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

deepesh1 — Sat, 05 Aug 2017 01:22:12 GMT

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>

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

pvln_reddy1919 — Sat, 05 Aug 2017 01:30:39 GMT

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

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

deepesh1 — Sat, 05 Aug 2017 01:34:23 GMT

So indeed it was a corrupted client, in that case please accept my first answer.