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

Drill allows "SELECT *, *" query

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: 1.10.0
    • Fix Version/s: None
    • Component/s: Storage - Text & CSV
    • Labels:
      None

      Description

      Configure the CSV storage plugin to not read the header row. Create a simple CSV file:

      10,foo,bar
      

      Issue the following nonsensical query:

      SELECT *, * FROM `dfs.data`.`example.csv`
      

      Get the following results:

      columns,columns0
      ["10","foo","bar"],["10","foo","bar"]
      

      Expected an error as using two unqualified *'s is not valid SQL.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              paul-rogers Paul Rogers
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: