Jayesh-Asrani opened a new issue, #13593:
URL: https://github.com/apache/pinot/issues/13593

   1. We are trying to execute a Funnel Count Query as mentioned below 
    `select FUNNEL_COUNT(
       STEPS(
         event_name = 'A',
         event_name = 'B',
         event_name = 'C',
         event_name = 'D'
       ),
       CORRELATE_BY(user_id)
     ) AS counts
   from events
   where event_type in (
       'app_open',
       'catalog_opened',
       'add_to_cart_clicked',
       'buy_now_clicked'
     )
     and event_time >= 1719253800
     and event_time <= 1719340200`
   
   2. The query fails with an NPE error 
   
   > QueryExecutionError:
   java.lang.NullPointerException: Cannot read field "_dictionary" because 
"dictIdsWrapper" is null
        at 
org.apache.pinot.core.query.aggregation.function.funnel.BitmapResultExtractionStrategy.extractIntermediateResult(BitmapResultExtractionStrategy.java:38)
        at 
org.apache.pinot.core.query.aggregation.function.funnel.BitmapResultExtractionStrategy.extractIntermediateResult(BitmapResultExtractionStrategy.java:29)
        at 
org.apache.pinot.core.query.aggregation.function.funnel.ResultExtractionStrategy.extractAggregationResult(ResultExtractionStrategy.java:41)
        at 
org.apache.pinot.core.query.aggregation.function.funnel.FunnelCountAggregationFunction.extractAggregationResult(FunnelCountAggregationFunction.java:139)
   
   3. If we however remove the filter on the event_type predicate the query 
seems to be working as expected 
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org

Reply via email to