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

Specifying schema=dfs and not specifying schema at query does not work

    XMLWordPrintableJSON

    Details

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

      Description

      Repro steps:

      Start sqlline
      bin/sqlline -u jdbc:drill:schema=dfs -n admin -p admin

      0: jdbc:drill:schema=dfs> select * from `/region.parquet`;
      Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "76bae1a1-3b86-4dc8-9cd4-6e42cb7fe900"
      endpoint {
      address: "perfnode166.perf.lab"
      user_port: 31010
      control_port: 31011
      data_port: 31012
      }
      error_type: 0
      message: "Failure while parsing sql. < ValidationException:[ org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to line 1, column 31 ] < EigenbaseContextException:[ From line 1, column 15 to line 1, column 31 ] < SqlValidatorException:[ Table \'/region.parquet\' not found ]"
      ]
      Error: exception while executing query (state=,code=0)

      This works though.
      0: jdbc:drill:schema=dfs> select * from dfs.`region.parquet`;

      Also, specifying cp as schema works.

      [root@perfnode166 drill]# bin/sqlline -u jdbc:drill:schema=cp -n admin -p admin

      0: jdbc:drill:schema=cp> select * from `employee.json`;

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vkorukanti Venki Korukanti
                Reporter:
                inramana Ramana Inukonda Nagaraj
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: