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

["Parth Chandra (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-2374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Parth Chandra updated DRILL-2374:
---------------------------------
    Fix Version/s: Future

> 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)
>             Fix For: Future
>
>
> *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)