buchi-busireddy commented on issue #5691:
URL:
https://github.com/apache/incubator-pinot/issues/5691#issuecomment-714734203
FYI, seeing these exceptions in the latest `0.5.0` pinot release when trying
to group by multiple columns which also includes `BYTES` columns.
```java
2020-10-22 19:48:20.591 [grpc-default-executor-779] ERROR
o.h.c.q.s.p.PinotBasedRequestHandler - An error occurred while executing:
Select dateTimeConvert(start_time_millis,?,?,?), trace_id, COUNT(*) FROM
spanEventView WHERE customer_id = ? AND ( ( start_time_millis >= ? AND
start_time_millis < ? ) AND ( api_boundary_type = ? AND api_id != ? AND (
trace_id IN (?, ?, ?, ?, ?) ) ) ) GROUP BY
dateTimeConvert(start_time_millis,?,?,?), trace_id limit
50000org.apache.pinot.client.PinotClientException: Query had processing
exceptions:[{"message":"QueryExecutionError:\norg.apache.pinot.core.query.exception.BadQueryRequestException:
java.lang.IllegalArgumentException: Value:
{\"bytes\":\"Caw9KXf+zBjdF1rFAXsSuA==\"} is not Hex encoded
at
org.apache.pinot.core.operator.filter.predicate.PredicateEvaluatorProvider.getPredicateEvaluator(PredicateEvaluatorProvider.java:84)
at
org.apache.pinot.core.plan.FilterPlanNode.constructPhysicalOperator(FilterPlanNode.java:130)
at
org.apache.pinot.core.plan.FilterPlanNode.constructPhysicalOperator(FilterPlanNode.java:77)
at org.apache.pinot.core.plan.FilterPlanNode.run(FilterPlanNode.java:61)
at org.apache.pinot.core.plan.DocIdSetPlanNode.run(DocIdSetPlanNode.java:41)
at
org.apache.pinot.core.plan.ProjectionPlanNode.run(ProjectionPlanNode.java:52)
at
org.apache.pinot.core.plan.TransformPlanNode.run(TransformPlanNode.java:52)
at
org.apache.pinot.core.plan.AggregationGroupByOrderByPlanNode.run(AggregationGroupByOrderByPlanNode.java:107)
at
org.apache.pinot.core.plan.AggregationGroupByOrderByPlanNode.run(AggregationGroupByOrderByPlanNode.java:40)
at org.apache.pinot.core.plan.CombinePlanNode.run(CombinePlanNode.java:89)
at
org.apache.pinot.core.plan.InstanceResponsePlanNode.run(InstanceResponsePlanNode.java:33)
at
org.apache.pinot.core.plan.GlobalPlanImplV0.execute(GlobalPlanImplV0.java:45)
at
org.apache.pinot.core.query.executor.ServerQueryExecutorV1Impl.processQuery(ServerQueryExecutorV1Impl.java:221)
at
org.apache.pinot.core.query.scheduler.QueryScheduler.processQueryAndSerialize(QueryScheduler.java:155)","errorCode":200},{"message":"QueryExecutionError:\norg.apache.pinot.core.query.exception.BadQueryRequestException:
java.lang.IllegalArgumentException: Value:
{\"bytes\":\"Caw9KXf+zBjdF1rFAXsSuA==\"} is not Hex encoded
at
org.apache.pinot.core.operator.filter.predicate.PredicateEvaluatorProvider.getPredicateEvaluator(PredicateEvaluatorProvider.java:84)
at
org.apache.pinot.core.plan.FilterPlanNode.constructPhysicalOperator(FilterPlanNode.java:130)
at
org.apache.pinot.core.plan.FilterPlanNode.constructPhysicalOperator(FilterPlanNode.java:77)
at org.apache.pinot.core.plan.FilterPlanNode.run(FilterPlanNode.java:61)
at org.apache.pinot.core.plan.DocIdSetPlanNode.run(DocIdSetPlanNode.java:41)
at
org.apache.pinot.core.plan.ProjectionPlanNode.run(ProjectionPlanNode.java:52)
at
org.apache.pinot.core.plan.TransformPlanNode.run(TransformPlanNode.java:52)
at
org.apache.pinot.core.plan.AggregationGroupByOrderByPlanNode.run(AggregationGroupByOrderByPlanNode.java:107)
at
org.apache.pinot.core.plan.AggregationGroupByOrderByPlanNode.run(AggregationGroupByOrderByPlanNode.java:40)
at org.apache.pinot.core.plan.CombinePlanNode.run(CombinePlanNode.java:89)
at
org.apache.pinot.core.plan.InstanceResponsePlanNode.run(InstanceResponsePlanNode.java:33)
at
org.apache.pinot.core.plan.GlobalPlanImplV0.execute(GlobalPlanImplV0.java:45)
at
org.apache.pinot.core.query.executor.ServerQueryExecutorV1Impl.processQuery(ServerQueryExecutorV1Impl.java:221)
at
org.apache.pinot.core.query.scheduler.QueryScheduler.processQueryAndSerialize(QueryScheduler.java:155)","errorCode":200},{"message":"QueryExecutionError:\norg.apache.pinot.core.query.exception.BadQueryRequestException:
java.lang.IllegalArgumentException: Value:
{\"bytes\":\"Caw9KXf+zBjdF1rFAXsSuA==\"} is not Hex encoded
at
org.apache.pinot.core.operator.filter.predicate.PredicateEvaluatorProvider.getPredicateEvaluator(PredicateEvaluatorProvider.java:84)
at
org.apache.pinot.core.plan.FilterPlanNode.constructPhysicalOperator(FilterPlanNode.java:130)
at
org.apache.pinot.core.plan.FilterPlanNode.constructPhysicalOperator(FilterPlanNode.java:77)
at org.apache.pinot.core.plan.FilterPlanNode.run(FilterPlanNode.java:61)
at org.apache.pinot.core.plan.DocIdSetPlanNode.run(DocIdSetPlanNode.java:41)
at
org.apache.pinot.core.plan.ProjectionPlanNode.run(ProjectionPlanNode.java:52)
at
org.apache.pinot.core.plan.TransformPlanNode.run(TransformPlanNode.java:52)
at
org.apache.pinot.core.plan.AggregationGroupByOrderByPlanNode.run(AggregationGroupByOrderByPlanNode.java:107)
at
org.apache.pinot.core.plan.AggregationGroupByOrderByPlanNode.run(AggregationGroupByOrderByPlanNode.java:40)
at org.apache.pinot.core.plan.CombinePlanNode.run(CombinePlanNode.java:89)
at
org.apache.pinot.core.plan.InstanceResponsePlanNode.run(InstanceResponsePlanNode.java:33)
at
org.apache.pinot.core.plan.GlobalPlanImplV0.execute(GlobalPlanImplV0.java:45)
at
org.apache.pinot.core.query.executor.ServerQueryExecutorV1Impl.processQuery(ServerQueryExecutorV1Impl.java:221)
at
org.apache.pinot.core.query.scheduler.QueryScheduler.processQueryAndSerialize(QueryScheduler.java:155)","errorCode":200}]
```
cc @Jackie-Jiang
----------------------------------------------------------------
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
