Akshay2Agarwal opened a new issue, #8541: URL: https://github.com/apache/pinot/issues/8541
Facing an issue in pinot where queries like (as mentioned over [docs](https://docs.pinot.apache.org/configuration-reference/functions/now)): ``` SELECT * FROM table_name WHER time_ms_epoch_col > now() - 86400000 * 7 LIMIT 10 ``` fails over at this [line](https://github.com/apache/pinot/blob/release-0.10.0/pinot-spi/src/main/java/org/apache/pinot/spi/data/FieldSpec.java#L486) due to conversion failure. Logs: ``` 'QueryExecutionError:\n' 'org.apache.pinot.spi.exception.BadQueryRequestException: ' 'java.lang.IllegalArgumentException: Cannot convert value: ' "'1.649312982053E12' to type: LONG\n" '\tat ' 'org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.convertValue(ColumnValueSegmentPruner.java:424)\n' '\tat ' 'org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.pruneRangePredicate(ColumnValueSegmentPruner.java:369)\n' '\tat ' 'org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.pruneSegment(ColumnValueSegmentPruner.java:230)\n' '\tat ' 'org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.prune(ColumnValueSegmentPruner.java:160)\n' '...\n' 'Caused by: java.lang.IllegalArgumentException: Cannot convert ' "value: '1.649312982053E12' to type: LONG\n" '\tat ' 'org.apache.pinot.spi.data.FieldSpec$DataType.convertInternal(FieldSpec.java:510)\n' '\tat ' 'org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.convertValue(ColumnValueSegmentPruner.java:422)\n' '\t... 17 more' ``` -- 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
