abhioncbr commented on issue #10921: URL: https://github.com/apache/pinot/issues/10921#issuecomment-1606536699
I tried to use the [Calcite SqlAdvisor code](https://github.com/apache/calcite/blob/main/core/src/main/java/org/apache/calcite/sql/advise/SqlAdvisor.java#L603) mentioned in my above comment for the below incorrect query ```SELECT intCol FROMM select_expression_test_tbl1``` and the error message I got for the above query is below ``` Encountered "select_expression_test_tbl1" at line 1, column 21. Was expecting one of: <EOF> "EXCEPT" ... "FETCH" ... "FROM" ... "INTERSECT" ... "LIMIT" ... "OFFSET" ... "ORDER" ... "MINUS" ... "UNION" ... "," ... ``` It is a bit much better than our current exception message content ``` Encountered " <IDENTIFIER> "select_expression_test_tbl1 "" at line 1, column 21. Was expecting: <EOF> ``` I am not sure if it's more helpful or not. @walterddr do you have any ideas around this? Thanks -- 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]
