Apache Drill
  1. Apache Drill
  2. DRILL-397

need to be able to specify schema through sqlline

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Duplicate
    • Affects Version/s: 0.5.0
    • Fix Version/s: 0.4.0
    • Component/s: None
    • Labels:
      None

      Description

      Before the current merge, we can specify schema through sqlline like this:

      ./sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin

      We need this feature be restored so we don't need to modify our existing queries to add storage engine type such as cp.`employee.json`.

        Issue Links

          Activity

          Chun Chang created issue -
          Hide
          Ramana Inukonda Nagaraj added a comment -

          Feature exists currently.
          Its currently broken. Works for cp, does not work for dfs.

          https://issues.apache.org/jira/browse/DRILL-399
          Describes the issue.

          Show
          Ramana Inukonda Nagaraj added a comment - Feature exists currently. Its currently broken. Works for cp, does not work for dfs. https://issues.apache.org/jira/browse/DRILL-399 Describes the issue.
          Ramana Inukonda Nagaraj made changes -
          Field Original Value New Value
          Link This issue duplicates DRILL-399 [ DRILL-399 ]
          Jacques Nadeau made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Duplicate [ 3 ]
          Hide
          Chun Chang added a comment -

          this has been fixed.

          bin/sqlline -n admin -p admin -u "jdbc:drill:schema=dfs;zk=10.10.100.118:5181,10.10.100.119:5181,10.10.100.120:5181"

          Show
          Chun Chang added a comment - this has been fixed. bin/sqlline -n admin -p admin -u "jdbc:drill:schema=dfs;zk=10.10.100.118:5181,10.10.100.119:5181,10.10.100.120:5181"
          Chun Chang made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Jake Farrell made changes -
          Workflow no-reopen-closed, patch-avail [ 12846119 ] no-reopen-closed, patch-avail, testing [ 12860184 ]
          Jacques Nadeau made changes -
          Fix Version/s 0.4.0 [ 12324963 ]
          Tony Stevenson made changes -
          Workflow no-reopen-closed, patch-avail, testing [ 12860184 ] Drill workflow [ 12934191 ]
          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Resolved Resolved
          1d 4h 8m 1 Jacques Nadeau 07/Mar/14 02:58
          Resolved Resolved Closed Closed
          45d 20h 37m 1 Chun Chang 22/Apr/14 00:35

            People

            • Assignee:
              Unassigned
              Reporter:
              Chun Chang
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development