[DRILL-4991] NPE when running CTAS auto partition on date and varchar columns

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Storage - Parquet
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 02/Nov/16 23:50
• Updated: 14/Mar/17 19:56

Description

git.commit.id.abbrev=4ee1d4c

The below ctas query fails with NPE

create table item_multipart partition by (i_rec_start_date, i_size) as select * from item;
Error: SYSTEM ERROR: NullPointerException

Fragment 0:0

[Error Id: 0f861e32-4d14-461e-bfc3-b75fd3ac6668 on qa-node190.qa.lab:31010] (state=,code=0)

There are null values for i_size column for some of the records. Still not sure if this is expected though. This is also happening in drill 1.8 as well

Issue Links

• duplicates: DRILL-4024 CTAS with auto partition gives an NPE when the partition column has null values in it