yashmayya commented on issue #14052:
URL: https://github.com/apache/pinot/issues/14052#issuecomment-2367387741
@piby180 I see the same error on 1.1.0 as well when using the multi-stage
query engine:
```
ProcessingException(errorCode:150, message:SQLParsingError:
java.lang.Exception: Unable to find table for this query
at
org.apache.pinot.controller.api.resources.PinotQueryResource.getMultiStageQueryResponse(PinotQueryResource.java:214)
at
org.apache.pinot.controller.api.resources.PinotQueryResource.executeSqlQuery(PinotQueryResource.java:177)
at
org.apache.pinot.controller.api.resources.PinotQueryResource.handlePostSql(PinotQueryResource.java:125)
at
java.base/jdk.internal.reflect.DirectMethodHandleAccessor.invoke(DirectMethodHandleAccessor.java:103)
...
Caused by: java.lang.RuntimeException: Error composing query plan for:
SELECT CAST(1.2 AS STRING) FROM airlineStats;
at
org.apache.pinot.query.QueryEnvironment.getTableNamesForQuery(QueryEnvironment.java:218)
at
org.apache.pinot.controller.api.resources.PinotQueryResource.getMultiStageQueryResponse(PinotQueryResource.java:212)
... 26 more
Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1,
column 20 to line 1, column 25: Unknown identifier 'STRING'
at
java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:62)
at
java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:502)
at
java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:486)
at
org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:505)
...
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Unknown
identifier 'STRING'
at
java.base/jdk.internal.reflect.DirectConstructorHandleAccessor.newInstance(DirectConstructorHandleAccessor.java:62)
at
java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:502)
at
java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:486)
at
org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:505))
```
AFAIK, the multi-stage query engine never supported `STRING` as a valid cast
type and it was always `VARCHAR`. This is documented here -
https://docs.pinot.apache.org/reference/troubleshooting/troubleshoot-multi-stage-query-engine#different-type-names
--
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]
