lgo opened a new issue #7868:
URL: https://github.com/apache/pinot/issues/7868
While writing some adhoc queries, I found the controller query console was
throwing a 500 and I was scratching my head about the error until I realized
the query was incorrect. I'm not sure if Pinot often 500s on invalid queries,
or this is a corner case, but certainly making sure a helpful error is returned
is better that informs the user their query is invalid.
For example, I was trying
```sql
select $segmentName, count(*)
from table
where $segmentName = 'bar'
```
Mind, the same error happened when I used actual columns rather than the
virtual column.
And it was raising the following 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))
```
--
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]
