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

CTAS with auto partition gives an NPE when the partition column has null values in it

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • None
    • None
    • Storage - Writer
    • None

    Description

      git.commit.id.abbrev=522eb81

      The data set used contains null values in the partition column. This causes the below query to fail with an NPE

      create table fewtypesnull_varcharpartition partition by (varchar_col) as select * from dfs.`/drill/testdata/cross-sources/fewtypes_null.parquet`;
      Error: SYSTEM ERROR: NullPointerException
      
      Fragment 0:0
      
      [Error Id: 6ef352c0-a12d-477c-bba8-e4a747a6b78e on qa-node190.qa.lab:31010] (state=,code=0)
      

      I attached the data set and error log. Let me know if more information is needed

      Attachments

        1. error.log
          6 kB
          Rahul Kumar Challapalli
        2. fewtypes_null.parquet
          2 kB
          Rahul Kumar Challapalli

        Issue Links

          Activity

            People

              Unassigned Unassigned
              rkins Rahul Kumar Challapalli
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: