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

Empty parquet file created with Limit 0 query errors out when querying

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.7.0
    • Fix Version/s: Future
    • Component/s: Storage - Parquet
    • Labels:
      None

      Description

      Doing a CTAS with limit 0 creates a 0 length parquet file which errors out during querying. This should at least write the schema information and metadata which will allow queries to run.

      0: jdbc:drill:zk=local> create table tt_nation2 as select n_nationkey, n_name, n_regionkey from cp.`tpch/nation.parquet` limit 0;
      +------------+---------------------------+
      |  Fragment  | Number of records written |
      +------------+---------------------------+
      | 0_0        | 0                         |
      +------------+---------------------------+
      1 row selected (0.315 seconds)
      0: jdbc:drill:zk=local> select n_nationkey from tt_nation2;
      Query failed: RuntimeException: file:/tmp/tt_nation2/0_0_0.parquet is not a Parquet file (too small)
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                amansinha100 Aman Sinha
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: