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

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.7.0
    • Future
    • Storage - Parquet
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: