[DRILL-6622] UNION on tpcds sf100 tables hit SYSTEM ERROR: NullPointerException

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.14.0
• Component/s: Execution - Codegen
• Labels: ready-to-commit
• Assignee: Salim Achouche
• Reporter: Vitalii Diravka
• Reviewer: Boaz Ben-Zvi
• Created: 19/Jul/18 21:06
• Updated: 23/Jul/18 20:20
• Resolved: 23/Jul/18 17:55

Description

SELECT c_customer_id FROM customer 
UNION
SELECT ca_address_id FROM customer_address 
UNION
SELECT cd_credit_rating FROM customer_demographics 
UNION
SELECT hd_buy_potential FROM household_demographics 
UNION
SELECT i_item_id FROM item 
UNION
SELECT p_promo_id FROM promotion 
UNION
SELECT t_time_id FROM time_dim 
UNION
SELECT d_date_id FROM date_dim 
UNION
SELECT s_store_id FROM store 
UNION
SELECT w_warehouse_id FROM warehouse 
UNION
SELECT sm_ship_mode_id FROM ship_mode 
UNION
SELECT r_reason_id FROM reason 
UNION
SELECT cc_call_center_id FROM call_center 
UNION
SELECT web_site_id FROM web_site 
UNION
SELECT wp_web_page_id FROM web_page 
UNION
SELECT cp_catalog_page_id FROM catalog_page;

hit the following error:

Caused by: java.lang.NullPointerException: null
        at org.apache.drill.exec.expr.fn.impl.ByteFunctionHelpers.compare(ByteFunctionHelpers.java:96) ~[vector-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
        at org.apache.drill.exec.test.generated.HashTableGen3$BatchHolder.isKeyMatchInternalBuild(BatchHolder.java:171) ~[na:na]
        at org.apache.drill.exec.physical.impl.common.HashTableTemplate$BatchHolder.isKeyMatch(HashTableTemplate.java:218) ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
        at org.apache.drill.exec.physical.impl.common.HashTableTemplate$BatchHolder.access$1000(HashTableTemplate.java:120) ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
        at org.apache.drill.exec.physical.impl.common.HashTableTemplate.put(HashTableTemplate.java:650) ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
        at org.apache.drill.exec.test.generated.HashAggregatorGen0.checkGroupAndAggrValues(HashAggTemplate.java:1372) ~[na:na]
        at org.apache.drill.exec.test.generated.HashAggregatorGen0.doWork(HashAggTemplate.java:599) ~[na:na]
        at org.apache.drill.exec.physical.impl.aggregate.HashAggBatch.innerNext(HashAggBatch.java:268) ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
        at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:172) ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
        at org.apache.drill.exec.record.AbstractRecordBatch.next(AbstractRecordBatch.java:119) ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]
        at org.apache.drill.exec.physical.impl.union.UnionAllRecordBatch$UnionInputIterator.next(UnionAllRecordBatch.java:381) ~[drill-java-exec-1.14.0-SNAPSHOT.jar:1.14.0-SNAPSHOT]

dechanggu found that the issue is absent in Drill 1.13.

Issue Links

• links to: GitHub Pull Request #1391