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

Does not support query of the form SELECT `schema`.`table`.* FROM `schema`.table`

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: Future
    • Component/s: SQL Parser
    • Labels:
      None
    • Environment:

      LINUX UBUNTU, WINDOWS 7

      Description

      Query of the form Select `schema`.`table`.* from `schema`.table` returns an error from the parser. This affects loading data to TIBCO Spotfire BI tool.

      sqlline query and returned error:

      0: jdbc:drill:schema=hbase> SELECT `hive43.default`.`bella_table`.* FROM `hive43.default`.`bella_table`;
      Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "186471ae-6271-4b74-91d5-fbe80e6675d2"
      endpoint {
      address: "192.168.39.43"
      user_port: 31010
      control_port: 31011
      data_port: 31012
      }
      error_type: 0
      message: "Failure while parsing sql. < SqlParseException:[ Encountered ". *" at line 1, column 39.
      Was expecting one of:
      "FROM" ...
      "," ...
      "AS" ...
      <IDENTIFIER> ...
      <QUOTED_IDENTIFIER> ...
      <BACK_QUOTED_IDENTIFIER> ...
      <BRACKET_QUOTED_IDENTIFIER> ...
      <UNICODE_QUOTED_IDENTIFIER> ...
      "NOT" ...
      "IN" ...
      "BETWEEN" ...
      "LIKE" ...
      "SIMILAR" ...
      "=" ...
      ">" ...
      "<" ...
      "<=" ...
      ">=" ...
      "<>" ...
      "+" ...
      "-" ...
      "*" ...
      "/" ...
      "||" ...
      "AND" ...
      "OR" ...
      "IS" ...
      "MEMBER" ...
      "SUBMULTISET" ...
      "MULTISET" ...
      "[" ...
      "." <IDENTIFIER> ...
      "." <QUOTED_IDENTIFIER> ...
      "." <BACK_QUOTED_IDENTIFIER> ...
      "." <BRACKET_QUOTED_IDENTIFIER> ...
      "." <UNICODE_QUOTED_IDENTIFIER> ...
      "(" ...
      ]"
      ]
      Error: exception while executing query (state=,code=0)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                alzarei Alexander Zarei
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: