drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2374) Sqlline prompt history needs improvements
Date Wed, 04 Mar 2015 01:52:05 GMT
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)

Mime
View raw message