Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-2374

Sqlline prompt history needs improvements

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.8.0
    • Fix Version/s: 1.15.0
    • Component/s: Client - CLI
    • Labels:
      None

      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.

        Attachments

          Activity

            People

            • Assignee:
              arina Arina Ielchiieva
              Reporter:
              agirish Abhishek Girish
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: