godfrey he created FLINK-23435: ---------------------------------- Summary: 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 Fix For: 1.14.0, 1.13.3
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. -- This message was sent by Atlassian Jira (v8.3.4#803005)