[jira] [Created] (DRILL-2374) Sqlline prompt history needs improvements

["Abhishek Girish (JIRA)" <ji...@apache.org>]

Abhishek Girish created DRILL-2374:
--------------------------------------

             Summary: Sqlline prompt history needs improvements
                 Key: DRILL-2374
                 URL: https://issues.apache.org/jira/browse/DRILL-2374
             Project: Apache Drill
          Issue Type: Improvement
          Components: Client - CLI
    Affects Versions: 0.8.0
            Reporter: Abhishek Girish
            Assignee: Daniel Barclay (Drill)


*On Sqlline:*
{code:sql}
> select id from customer 
. . . . . . . . . . . . . . . . . > limit 1;
+---------------+
| id |
+---------------+
| 1             |
+---------------+
1 row selected (0.095 seconds)

[Up arrow]
> limit 1;
{code}

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:*
{code:sql}
=# select c_customer_sk from customer
-# limit 1;
 c_customer_sk 
---------------
             1
(1 row)

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

*Or with shell prompt:*
{code}
# for i in `seq 1 5` 
> do
> mkdir $i
> done

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

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



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)