JKL98ISR opened a new issue #7461:
URL: https://github.com/apache/pinot/issues/7461
I have a field called date in my database so I need to use double quotes to
not get a parse error.
When I use double quotes in the Pinot console UI it runs the query normally.
In Presto it seems like the double quotes are removed before the
compilation.
When I process the query: `SELECT "date" from <table> LIMIT 10` I get the
following error:
`PrestoExternalError(type=EXTERNAL, name=PINOT_EXCEPTION, message="Query
SELECT date FROM <table> LIMIT 10 encountered exception
{"message":"PQLParsingError:\norg.apache.pinot.sql.parsers.SqlCompilationException:
Caught exception while parsing query: SELECT date FROM <table> LIMIT 10\n\tat
org.apache.pinot.sql.parsers.CalciteSqlParser.compileCalciteSqlToPinotQuery(CalciteSqlParser.java:327)\n\tat
org.apache.pinot.sql.parsers.CalciteSqlParser.compileToPinotQuery(CalciteSqlParser.java:110)\n\tat
org.apache.pinot.sql.parsers.CalciteSqlCompiler.compileToBrokerRequest(CalciteSqlCompiler.java:35)\n\tat
org.apache.pinot.core.requesthandler.PinotQueryParserFactory.parseSQLQuery(PinotQueryParserFactory.java:49)\n\tat
org.apache.pinot.broker.requesthandler.BaseBrokerRequestHandler.handleSQLRequest(BaseBrokerRequestHandler.java:212)\n\tat
org.apache.pinot.broker.requesthandler.BaseBrokerRequestHandler.handleRequest(BaseBrokerRequestHandler.java:194)\n\tat
org.apache.pinot.broker.requesthandl
er.BaseBrokerRequestHandler.handleRequest(BaseBrokerRequestHandler.java:99)\n\tat
org.apache.pinot.broker.api.resources.PinotClientRequest.processSqlQueryPost(PinotClientRequest.java:191)\n\tat
jdk.internal.reflect.GeneratedMethodAccessor94.invoke(Unknown Source)\n\tat
java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\n\tat
java.base/java.lang.reflect.Method.invoke(Method.java:566)\n\tat
org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory.lambda$static$0(ResourceMethodInvocationHandlerFactory.java:52)\n\tat
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:124)\n\tat
org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:167)","errorCode":150}
with pinot query "SELECT date FROM <table> LIMIT 10"",
query_id=20210922_140305_00041_tmeq6)`
Anyone came across this?
--
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]
