question Re: beeline - no current connection in Archives of Support Questions (Read Only)

beeline - no current connection

NicHopper — Thu, 26 Jan 2017 22:47:30 GMT

Hi,

I'm currently working through tutorial

http://hortonworks.com/hadoop-tutorial/hello-world-an-introduction-to-hadoop-hcatalog-hive-and-pig/#section_4

Section 2.2.10 - Beeline

As instructed I do the following

1. Run Putty

2. Login as maria_dev

3. run 'sudo su hive' (su hive just asks me for a password and I've tried maria_dev's and roots with no luck)

4. run 'beeline'

5. beeline starts and I get the version number and the prompt changes to beeline>

But then no matter what I run I get the message back 'No current connection'.

Even if I run 'quit;' The steps in the tutorial seem pretty basic so I dont know where I'm going wrong. Any ideas?

Thanks, Nic

Re: beeline - no current connection

KuldeepK — Thu, 26 Jan 2017 22:54:00 GMT

@Nic Hopper

After entering into beeline shell, you need to give connection string to connect to Hiveserver2.

Please use below command in beeline shell to connect to HS2

!connect jdbc:hive2://<hiveserver2-hostname-or-ip>:10000/<database-name>

After you run above command, you will have to provide username and password based on authentication mechanism that you have configured for Hiveserver2 (by default it's none)

Please refer below document for more details

https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients

Re: beeline - no current connection

dkozlowski — Thu, 26 Jan 2017 23:13:38 GMT

@Nic Hopper

If you have Kerberos enabled you need to connect as:

!connect jdbc:hive2://<hiveserver2_hostname>:10001/<database_name>;transportMode=http;httpPath=cliservice;principal=<hive_principal>

Re: beeline - no current connection

NicHopper — Fri, 27 Jan 2017 16:59:15 GMT

Thank you both for the responses. Greatly appreciate both.

Kuldeep - That worked perfectly

Daniel - Very useful to know, I'm sure it will end up being used down the line.