You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2022/04/13 15:47:37 UTC

[GitHub] [pinot] richardstartin opened a new issue, #8534: CAST function is not calculated at compile time which prevents usage of index/metadata

richardstartin opened a new issue, #8534:
URL: https://github.com/apache/pinot/issues/8534

   This query 
   ```sql
   select count(*) from complexWebsite where hoursSinceEpoch > cast(0.0 as long)
   ```
   
   ```json
   "timeUsedMs": 341,
   "numEntriesScannedInFilter": 7500000
   ```
   
   ```
   BROKER_REDUCE(limit:10) 
   COMBINE_AGGREGATE 
   AGGREGATE(aggregations:count(*))
   TRANSFORM_PASSTHROUGH()
   PROJECT()
   DOC_ID_SET
   FILTER_EXPRESSION(operator:RANGE,predicate:minus(hoursSinceEpoch,cast('0.0','long')) > '0')
   ```
   
   is much slower than 
   ```sql
   select * from complexWebsite where hoursSinceEpoch > 0
   ```
   
   ```json
   "timeUsedMs": 3,
   "numEntriesScannedInFilter": 0
   ```
   
   ```
   BROKER_REDUCE(limit:10) 
   COMBINE_AGGREGATE 
   FAST_FILTERED_COUNT 
   FILTER_MATCH_ENTIRE_SEGMENT(docs:7500000)
   ```
   
   Because cast is not calculated at compile time. This results in the slow query not using metadata, because it doesn't know whether the function is volatile or constant.


-- 
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-unsubscribe@pinot.apache.org.apache.org

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


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

[GitHub] [pinot] richardstartin closed issue #8534: CAST function is not calculated at compile time which prevents usage of index/metadata

Posted by GitBox <gi...@apache.org>.
richardstartin closed issue #8534: CAST function is not calculated at compile time which prevents usage of index/metadata
URL: https://github.com/apache/pinot/issues/8534


-- 
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-unsubscribe@pinot.apache.org

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


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