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

Union All query fails stating that parquet files are schema less

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.9.0
    • None
    • Execution - Flow
    • None

    Description

      UNION ALL query over parquet files fails and reports that the Union-All was over schema-less tables.
      Parquet files are not with out a schema, they do have metadata. We need to fix this. Postgres returns results for the same query on same data.

      Drill 1.9.0
      git commit ID : a29f1e29

      0: jdbc:drill:schema=dfs.tmp> select * from `t_alltype.parquet` t1 union all select * from `t_alltype.parquet` t2;
      Error: UNSUPPORTED_OPERATION ERROR: Union-All over schema-less tables must specify the columns explicitly
      See Apache Drill JIRA: DRILL-2414
      
      
      [Error Id: b6069bdc-8697-4578-a799-802ff3e80f00 on centos-01.qa.lab:31010] (state=,code=0)
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            khfaraaz Khurram Faraaz
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: