How to quit beeline?

Question

I am using CDH 5.5 and need to use beeline. I am pretty new to it and learning it now. I can start beeline but cannot quit as we do in Hive. I need to use Ctrl+z to quit which is not the proper way. Can someone help?

Ahem - on Unix/Linux `CTRL-Z` means *STOP*, it does not terminate the program, it "freezes" it and returns control to the shell... without closing the connections nor de-allocating RAM & temp files. — Samson Scharfrichter, Mar 12 '16 at 21:21
For the record, the usual way to close a command-line utility in interactive mode is `CTRL-D` which means *OK, no more input, Stdin channel is closed, you can exit now* — Samson Scharfrichter, Mar 12 '16 at 21:25

score 36 · Answer 1 · answered Mar 12 '16 at 19:23

36

use !q or !quit

[cloudera@quickstart ~]$ beeline

Beeline version 1.1.0-cdh5.5.0 by Apache Hive

beeline> !q

[cloudera@quickstart ~]$

Thanks to Xuefu Zhang. Related Jira

answered Mar 12 '16 at 19:23

Alex Raj Kaliamoorthy

2,035
3
29
46

score 16 · Answer 2 · answered Jun 30 '17 at 18:40

16

Sometimes you may find yourself with some unterminated command that Hive still thinks that you are entering. If your "! quit" command isn't working, throw in a terminate character (;) and try to quit again.

---Example---

Beeline version 1.1.0-cdh5.7.1 by Apache Hive
beeline> some unterminated command
beeline> ! quit
beeline> <panic!>
beeline> <remember the need to terminate previous commands>
beeline> ;
No current connection
beeline> ! quit

answered Jun 30 '17 at 18:40

Jeremy Montgomery

161
1
4

This was such a lifesaver, I actually went into when the command didn't work for the first time :) – Devender Goyal Nov 12 '19 at 11:12

score 7 · Answer 3 · answered May 03 '17 at 17:51

7

I tried !q and also !quit it did not work in HDP 2.5./Beeline version 1.2.1000.2.5.3.

Finally

! quit or ! q (space required)

answered May 03 '17 at 17:51

Kumar

918
9
19

score 4 · Answer 4 · answered Oct 20 '16 at 20:09

4

Using Clouder 5.5.1,

used Ctrl+C to exit

answered Oct 20 '16 at 20:09

sld

59
2

That's not the proper way to terminate an application. – Alex Raj Kaliamoorthy Apr 10 '17 at 04:01

score 2 · Answer 5 · answered May 21 '16 at 01:44

2

Quitting beeline client:

!quit

answered May 21 '16 at 01:44

Suman

476
5
7

score 0 · Answer 6 · answered Jun 30 '16 at 13:01

0

beeline>!quit

This really helpful to quit the beeline

answered Jun 30 '16 at 13:01

Mister X

3,406
3
31
72

How to quit beeline?

6 Answers6