apucher opened a new issue #6228:
URL: https://github.com/apache/incubator-pinot/issues/6228
Hi everyone,
I ran into the following condition with BYTES-typed columns:
`SELECT * FROM mytable WHERE my_bytes_column = '146' -- '146' is a valid hex
string, but errors out. '0146' works.`
While seems to be a matter of taste, it may be worthwhile to support odd
length hex strings to provide a slightly more intuitive experience.
Addendum - Exception:
> [
> {
> "errorCode": 200,
> "message":
"QueryExecutionError:\norg.apache.pinot.core.query.exception.BadQueryRequestException:
Cannot convert value: '146' to type: BYTES\n\tat
org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.convertValue(ColumnValueSegmentPruner.java:261)\n\tat
org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.pruneEqPredicate(ColumnValueSegmentPruner.java:129)\n\tat
org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.pruneSegment(ColumnValueSegmentPruner.java:103)\n\tat
org.apache.pinot.core.query.pruner.ColumnValueSegmentPruner.prune(ColumnValueSegmentPruner.java:76)\n\tat
org.apache.pinot.core.query.pruner.SegmentPruner.prune(SegmentPruner.java:50)\n\tat
org.apache.pinot.core.query.pruner.SegmentPrunerService.prune(SegmentPrunerService.java:56)\n\tat
org.apache.pinot.core.query.executor.ServerQueryExecutorV1Impl.processQuery(ServerQueryExecutorV1Impl.java:206)\n\tat
org.apache.pinot.core.query.executor.QueryExecutor.processQuery(QueryExecutor.java:60)\n\t
at
org.apache.pinot.core.query.scheduler.QueryScheduler.processQueryAndSerialize(QueryScheduler.java:155)\n\tat
org.apache.pinot.core.query.scheduler.QueryScheduler.lambda$createQueryFutureTask$0(QueryScheduler.java:139)\n\tat
java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat
shaded.com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:111)\n\tat
shaded.com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:58)"
> }
> ]
----------------------------------------------------------------
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.
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
