[jira] [Created] (DRILL-6622) UNION on tpcds sf100 tables hit SYSTEM ERROR: NullPointerException

["Vitalii Diravka (JIRA)" <ji...@apache.org>]

Vitalii Diravka created DRILL-6622:
--------------------------------------

             Summary: UNION on tpcds sf100 tables hit SYSTEM ERROR: NullPointerException	
                 Key: DRILL-6622
                 URL: https://issues.apache.org/jira/browse/DRILL-6622
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Codegen
    Affects Versions: 1.14.0
            Reporter: Vitalii Diravka
             Fix For: 1.14.0


{code}
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;
{code}
hit the following error:
{code}
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]
{code}

[~dechanggu] found that the issue is absent in Drill 1.13.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)