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

UNION on tpcds sf100 tables hit SYSTEM ERROR: NullPointerException

    Details

      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]
      

      Dechang Gu found that the issue is absent in Drill 1.13.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sachouche salim achouche
                Reporter:
                vitalii Vitalii Diravka
                Reviewer:
                Boaz Ben-Zvi
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: