[
https://issues.apache.org/jira/browse/FLINK-23435?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
godfrey he updated FLINK-23435:
-------------------------------
Description:
when run the following query (join later table without as):
{code:sql}
SELECT * FROM MyTable, LATERAL TABLE(STRING_SPLIT(c, '|'))
{code}
we will get the following exception:
{code:java}
org.apache.flink.table.api.ValidationException: SQL validation failed. null
at
org.apache.flink.table.planner.calcite.FlinkPlannerImpl.org$apache$flink$table$planner$calcite$FlinkPlannerImpl$$validate(FlinkPlannerImpl.scala:155)
at
org.apache.flink.table.planner.calcite.FlinkPlannerImpl.validate(FlinkPlannerImpl.scala:112)
at
org.apache.flink.table.planner.operations.SqlToOperationConverter.convert(SqlToOperationConverter.java:195)
at
org.apache.flink.table.planner.operations.SqlToOperationConverter.convertSqlInsert(SqlToOperationConverter.java:576)
at
org.apache.flink.table.planner.operations.SqlToOperationConverter.convert(SqlToOperationConverter.java:260)
at
com.ververica.platform.sql.environment.VvpSqlParser.lambda$parse$5(VvpSqlParser.java:127)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
at
com.ververica.platform.sql.environment.VvpSqlParser.parse(VvpSqlParser.java:126)
at
com.ververica.platform.sql.service.SqlScriptValidationService$SqlScriptValidator.get(SqlScriptValidationService.java:156)
at
com.ververica.platform.sql.service.SqlScriptValidationService$SqlScriptValidator.get(SqlScriptValidationService.java:141)
at
com.ververica.platform.sql.classloader.ClassLoaderWrapper.execute(ClassLoaderWrapper.java:12)
at
com.ververica.platform.sql.service.SqlScriptValidationService.validate(SqlScriptValidationService.java:122)
at
com.ververica.platform.sql.service.SqlScriptValidationService.validate(SqlScriptValidationService.java:80)
at
com.ververica.platform.sql.service.SqlScriptValidationService.validate(SqlScriptValidationService.java:64)
at
com.ververica.platform.sql.service.SqlScriptValidationService.validate(SqlScriptValidationService.java:58)
at
com.ververica.platform.sql.service.SqlService.validateStatement(SqlService.java:465)
at
com.ververica.platform.sql.v1beta1.SqlServiceGrpc$MethodHandlers.invoke(SqlServiceGrpc.java:1194)
at
io.grpc.stub.ServerCalls$UnaryServerCallHandler$UnaryServerCallListener.onHalfClose(ServerCalls.java:172)
at
io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(ServerCallImpl.java:331)
at
io.grpc.internal.ServerImpl$JumpToApplicationThreadServerStreamListener$1HalfClosed.runInContext(ServerImpl.java:820)
at io.grpc.internal.ContextRunnable.run(ContextRunnable.java:37)
at io.grpc.internal.SerializingExecutor.run(SerializingExecutor.java:123)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:984)
Caused by: java.lang.NullPointerException
at
org.apache.calcite.rel.type.RelDataTypeFactoryImpl.addFields(RelDataTypeFactoryImpl.java:424)
at
org.apache.calcite.rel.type.RelDataTypeFactoryImpl.getFieldList(RelDataTypeFactoryImpl.java:389)
at
org.apache.calcite.rel.type.RelDataTypeFactoryImpl.createJoinType(RelDataTypeFactoryImpl.java:133)
at
org.apache.calcite.sql.validate.JoinNamespace.validateImpl(JoinNamespace.java:59)
at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3211)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3461)
at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1067)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1041)
at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:232)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1016)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:724)
at
org.apache.flink.table.planner.calcite.FlinkPlannerImpl.org$apache$flink$table$planner$calcite$FlinkPlannerImpl$$validate(FlinkPlannerImpl.scala:150)
... 24 more
{code}
The exception message is too obscure to know what the specific error is.
was:
when run the following query:
{code:sql}
SELECT * FROM MyTable, LATERAL TABLE(STRING_SPLIT(c, '|'))
{code}
we will get the following exception:
{code:java}
org.apache.flink.table.api.ValidationException: SQL validation failed. null
at
org.apache.flink.table.planner.calcite.FlinkPlannerImpl.org$apache$flink$table$planner$calcite$FlinkPlannerImpl$$validate(FlinkPlannerImpl.scala:155)
at
org.apache.flink.table.planner.calcite.FlinkPlannerImpl.validate(FlinkPlannerImpl.scala:112)
at
org.apache.flink.table.planner.operations.SqlToOperationConverter.convert(SqlToOperationConverter.java:195)
at
org.apache.flink.table.planner.operations.SqlToOperationConverter.convertSqlInsert(SqlToOperationConverter.java:576)
at
org.apache.flink.table.planner.operations.SqlToOperationConverter.convert(SqlToOperationConverter.java:260)
at
com.ververica.platform.sql.environment.VvpSqlParser.lambda$parse$5(VvpSqlParser.java:127)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
at
com.ververica.platform.sql.environment.VvpSqlParser.parse(VvpSqlParser.java:126)
at
com.ververica.platform.sql.service.SqlScriptValidationService$SqlScriptValidator.get(SqlScriptValidationService.java:156)
at
com.ververica.platform.sql.service.SqlScriptValidationService$SqlScriptValidator.get(SqlScriptValidationService.java:141)
at
com.ververica.platform.sql.classloader.ClassLoaderWrapper.execute(ClassLoaderWrapper.java:12)
at
com.ververica.platform.sql.service.SqlScriptValidationService.validate(SqlScriptValidationService.java:122)
at
com.ververica.platform.sql.service.SqlScriptValidationService.validate(SqlScriptValidationService.java:80)
at
com.ververica.platform.sql.service.SqlScriptValidationService.validate(SqlScriptValidationService.java:64)
at
com.ververica.platform.sql.service.SqlScriptValidationService.validate(SqlScriptValidationService.java:58)
at
com.ververica.platform.sql.service.SqlService.validateStatement(SqlService.java:465)
at
com.ververica.platform.sql.v1beta1.SqlServiceGrpc$MethodHandlers.invoke(SqlServiceGrpc.java:1194)
at
io.grpc.stub.ServerCalls$UnaryServerCallHandler$UnaryServerCallListener.onHalfClose(ServerCalls.java:172)
at
io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(ServerCallImpl.java:331)
at
io.grpc.internal.ServerImpl$JumpToApplicationThreadServerStreamListener$1HalfClosed.runInContext(ServerImpl.java:820)
at io.grpc.internal.ContextRunnable.run(ContextRunnable.java:37)
at io.grpc.internal.SerializingExecutor.run(SerializingExecutor.java:123)
at
java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at
java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:984)
Caused by: java.lang.NullPointerException
at
org.apache.calcite.rel.type.RelDataTypeFactoryImpl.addFields(RelDataTypeFactoryImpl.java:424)
at
org.apache.calcite.rel.type.RelDataTypeFactoryImpl.getFieldList(RelDataTypeFactoryImpl.java:389)
at
org.apache.calcite.rel.type.RelDataTypeFactoryImpl.createJoinType(RelDataTypeFactoryImpl.java:133)
at
org.apache.calcite.sql.validate.JoinNamespace.validateImpl(JoinNamespace.java:59)
at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3211)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3461)
at
org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
at
org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1067)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1041)
at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:232)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1016)
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:724)
at
org.apache.flink.table.planner.calcite.FlinkPlannerImpl.org$apache$flink$table$planner$calcite$FlinkPlannerImpl$$validate(FlinkPlannerImpl.scala:150)
... 24 more
{code}
The exception message is too obscure to know what the specific error is.
> Improve the exception message when a query has lateral table join without
> 'AS' which return type is simple type
> ---------------------------------------------------------------------------------------------------------------
>
> Key: FLINK-23435
> URL: https://issues.apache.org/jira/browse/FLINK-23435
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Affects Versions: 1.13.0, 1.14.0
> Reporter: godfrey he
> Assignee: godfrey he
> Priority: Major
> Fix For: 1.14.0, 1.13.3
>
>
> when run the following query (join later table without as):
> {code:sql}
> SELECT * FROM MyTable, LATERAL TABLE(STRING_SPLIT(c, '|'))
> {code}
> we will get the following exception:
> {code:java}
> org.apache.flink.table.api.ValidationException: SQL validation failed. null
> at
> org.apache.flink.table.planner.calcite.FlinkPlannerImpl.org$apache$flink$table$planner$calcite$FlinkPlannerImpl$$validate(FlinkPlannerImpl.scala:155)
> at
> org.apache.flink.table.planner.calcite.FlinkPlannerImpl.validate(FlinkPlannerImpl.scala:112)
> at
> org.apache.flink.table.planner.operations.SqlToOperationConverter.convert(SqlToOperationConverter.java:195)
> at
> org.apache.flink.table.planner.operations.SqlToOperationConverter.convertSqlInsert(SqlToOperationConverter.java:576)
> at
> org.apache.flink.table.planner.operations.SqlToOperationConverter.convert(SqlToOperationConverter.java:260)
> at
> com.ververica.platform.sql.environment.VvpSqlParser.lambda$parse$5(VvpSqlParser.java:127)
> at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
> at
> com.ververica.platform.sql.environment.VvpSqlParser.parse(VvpSqlParser.java:126)
> at
> com.ververica.platform.sql.service.SqlScriptValidationService$SqlScriptValidator.get(SqlScriptValidationService.java:156)
> at
> com.ververica.platform.sql.service.SqlScriptValidationService$SqlScriptValidator.get(SqlScriptValidationService.java:141)
> at
> com.ververica.platform.sql.classloader.ClassLoaderWrapper.execute(ClassLoaderWrapper.java:12)
> at
> com.ververica.platform.sql.service.SqlScriptValidationService.validate(SqlScriptValidationService.java:122)
> at
> com.ververica.platform.sql.service.SqlScriptValidationService.validate(SqlScriptValidationService.java:80)
> at
> com.ververica.platform.sql.service.SqlScriptValidationService.validate(SqlScriptValidationService.java:64)
> at
> com.ververica.platform.sql.service.SqlScriptValidationService.validate(SqlScriptValidationService.java:58)
> at
> com.ververica.platform.sql.service.SqlService.validateStatement(SqlService.java:465)
> at
> com.ververica.platform.sql.v1beta1.SqlServiceGrpc$MethodHandlers.invoke(SqlServiceGrpc.java:1194)
> at
> io.grpc.stub.ServerCalls$UnaryServerCallHandler$UnaryServerCallListener.onHalfClose(ServerCalls.java:172)
> at
> io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(ServerCallImpl.java:331)
> at
> io.grpc.internal.ServerImpl$JumpToApplicationThreadServerStreamListener$1HalfClosed.runInContext(ServerImpl.java:820)
> at io.grpc.internal.ContextRunnable.run(ContextRunnable.java:37)
> at io.grpc.internal.SerializingExecutor.run(SerializingExecutor.java:123)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
> at
> java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
> at java.base/java.lang.Thread.run(Thread.java:984)
> Caused by: java.lang.NullPointerException
> at
> org.apache.calcite.rel.type.RelDataTypeFactoryImpl.addFields(RelDataTypeFactoryImpl.java:424)
> at
> org.apache.calcite.rel.type.RelDataTypeFactoryImpl.getFieldList(RelDataTypeFactoryImpl.java:389)
> at
> org.apache.calcite.rel.type.RelDataTypeFactoryImpl.createJoinType(RelDataTypeFactoryImpl.java:133)
> at
> org.apache.calcite.sql.validate.JoinNamespace.validateImpl(JoinNamespace.java:59)
> at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3211)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3461)
> at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
> at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:84)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1067)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1041)
> at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:232)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1016)
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:724)
> at
> org.apache.flink.table.planner.calcite.FlinkPlannerImpl.org$apache$flink$table$planner$calcite$FlinkPlannerImpl$$validate(FlinkPlannerImpl.scala:150)
> ... 24 more
> {code}
> The exception message is too obscure to know what the specific error is.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
