[DRILL-2374] Sqlline prompt history needs improvements

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.8.0
• Fix Version/s: 1.15.0
• Component/s: Client - CLI
• Assignee: Arina Ielchiieva
• Reporter: Abhishek Girish
• Created: 04/Mar/15 01:51
• Updated: 03/Dec/18 13:10
• Resolved: 03/Dec/18 13:10

Description

On Sqlline:

> select id from customer 
. . . . . . . . . . . . . . . . . > limit 1;
+---------------+
| id |
+---------------+
| 1             |
+---------------+
1 row selected (0.095 seconds)

[Up arrow]
> limit 1;

Using the arrow keys, traversing through previously run queries is currently not useful, as it displays them line by line and not as a whole.

Compare it with Postgres:

=# select c_customer_sk from customer
-# limit 1;
 c_customer_sk 
---------------
             1
(1 row)

[Up arrow]
=# select c_customer_sk from customer
limit 1;

Or with shell prompt:

# for i in `seq 1 5` 
> do
> mkdir $i
> done

[Up arrow]
# for i in `seq 1 5` ; do mkdir $i; done

Sqlline should also support other such enhancements such as printing entire history.