mayankshriv commented on issue #7868: URL: https://github.com/apache/pinot/issues/7868#issuecomment-986155320
Hello Joey, Thanks for finding this issue. Do you mind creating a GitHub issue with details for both the problems you encountered? Also, please feel free to join the Apache Pinot slack community for more interactive discussions. Thanks Mayank > On Dec 4, 2021, at 11:07 AM, Joey Pereira ***@***.***> wrote: > > > 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 > > 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 > > 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)) > — > You are receiving this because you are subscribed to this thread. > Reply to this email directly, view it on GitHub, or unsubscribe. > Triage notifications on the go with GitHub Mobile for iOS or Android. -- 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]
