hristo-stripe opened a new issue #8008:
URL: https://github.com/apache/pinot/issues/8008
When I run the following query (replacing $number with a numerical value):
```sql
explain plan for select count(*) from t where col1=true and col2 >= $number
limit 10
```
I get results that don't show much:
```json
"rows": [
[
"BROKER_REDUCE(limit:10)",
0,
-1
],
[
0
]
]
```
The query itself produces a count successfully, however the explain plan
doesn't work at all.
If I try
```sql
explain plan for select * from t where col1=true and col2 >= $number limit 10
```
it crashes and I get the exception:
```
ProcessingException(errorCode:450, message:InternalError:
java.io.IOException: Failed : HTTP error code : 500
at
org.apache.pinot.controller.api.resources.PinotQueryResource.sendPostRaw(PinotQueryResource.java:305)
at
org.apache.pinot.controller.api.resources.PinotQueryResource.sendRequestRaw(PinotQueryResource.java:343)
at
org.apache.pinot.controller.api.resources.PinotQueryResource.getQueryResponse(PinotQueryResource.java:225)
at
org.apache.pinot.controller.api.resources.PinotQueryResource.handlePostSql(PinotQueryResource.java:137))
```
cc @amrishlal since it looks like you built most of that functionality.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
