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)