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

Sqlline Usage needs to be corrected

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.8.0
    • 1.1.0
    • Client - CLI
    • None

    Description

      Sqlline usage needs to be corrected.

      (1) Remove the statement "java sqlline.SqlLine "
      (2) Display usage only once

      >sqlline --help
      Drill log directory: /var/log/drill
      Usage: java sqlline.SqlLine 
         -u <database url>               the JDBC URL to connect to
         -n <username>                   the username to connect as
         -p <password>                   the password to connect as
         -d <driver class&gt;               the driver class to use
         --color=[true/false]            control whether color is used for display
         --showHeader=[true/false]       show column names in query results
         --headerInterval=ROWS;          the interval between which heades are displayed
         --fastConnect=[true/false]      skip building table/column list for tab-completion
         --autoCommit=[true/false]       enable/disable automatic transaction commit
         --verbose=[true/false]          show verbose error messages and debug info
         --showTime=[true/false]         display execution time when verbose
         --showWarnings=[true/false]     display connection warnings
         --showNestedErrs=[true/false]   display nested errors
         --numberFormat=[pattern]        format numbers using DecimalFormat pattern
         --force=[true/false]            continue running script even after errors
         --maxWidth=MAXWIDTH             the maximum width of the terminal
         --maxColumnWidth=MAXCOLWIDTH    the maximum width to use when displaying columns
         --silent=[true/false]           be more silent
         --autosave=[true/false]         automatically save preferences
         --outputformat=[table/vertical/csv/tsv]   format mode for result display
         --isolation=LEVEL               set the transaction isolation level
         --run=/path/to/file             run one script and then exit
      Usage: java sqlline.SqlLine 
         -u <database url>               the JDBC URL to connect to
         -n <username>                   the username to connect as
         -p <password>                   the password to connect as
         -d <driver class&gt;               the driver class to use
         --color=[true/false]            control whether color is used for display
         --showHeader=[true/false]       show column names in query results
         --headerInterval=ROWS;          the interval between which heades are displayed
         --fastConnect=[true/false]      skip building table/column list for tab-completion
         --autoCommit=[true/false]       enable/disable automatic transaction commit
         --verbose=[true/false]          show verbose error messages and debug info
         --showTime=[true/false]         display execution time when verbose
         --showWarnings=[true/false]     display connection warnings
         --showNestedErrs=[true/false]   display nested errors
         --numberFormat=[pattern]        format numbers using DecimalFormat pattern
         --force=[true/false]            continue running script even after errors
         --maxWidth=MAXWIDTH             the maximum width of the terminal
         --maxColumnWidth=MAXCOLWIDTH    the maximum width to use when displaying columns
         --silent=[true/false]           be more silent
         --autosave=[true/false]         automatically save preferences
         --outputformat=[table/vertical/csv/tsv]   format mode for result display
         --isolation=LEVEL               set the transaction isolation level
         --run=/path/to/file             run one script and then exit
      

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            agirish Abhishek Girish
            agirish Abhishek Girish
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment