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

CTAS has issues when the underlying query returns 0 results

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Duplicate
    • None
    • None
    • Storage - Parquet
    • None

    Description

      git.commit.id.abbrev=e92db23

      The below CTAS statement succeeds. Here the query in CTAS returns 0 results.

      create table empty_table as select columns[0] id from `rankings` where columns[0] < 0;

      However when I try to run any queries on top of it drill reports a failure

      select * from temp1;
Query failed: RuntimeException: maprfs:/drill/empty_table/0_0_0.parquet is not a Parquet file (too small)

Error: exception while executing query: Failure while executing query. (state=,code=0)

      Attached the error log file

      Attachments

        1. error.log
          6 kB
          Rahul Kumar Challapalli

        Issue Links

        duplicates

        Bug - A problem which impairs or prevents the functions of the product. DRILL-2408 CTAS should not create empty folders when underlying query returns no results

        • Major - Major loss of function.
        • Resolved

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            sphillips Steven Phillips
            rkins Rahul Kumar Challapalli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment