You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Sergey Nuyanzin (Jira)" <ji...@apache.org> on 2023/03/10 07:28:00 UTC

[jira] [Closed] (FLINK-31381) UnsupportedOperationException: Unsupported type when convertTypeToSpec: MAP

     [ https://issues.apache.org/jira/browse/FLINK-31381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sergey Nuyanzin closed FLINK-31381.
-----------------------------------
    Resolution: Duplicate

> UnsupportedOperationException: Unsupported type when convertTypeToSpec: MAP
> ---------------------------------------------------------------------------
>
>                 Key: FLINK-31381
>                 URL: https://issues.apache.org/jira/browse/FLINK-31381
>             Project: Flink
>          Issue Type: Bug
>          Components: Table SQL / Planner
>    Affects Versions: 1.18.0
>            Reporter: jackylau
>            Priority: Major
>
> when i fix this https://issues.apache.org/jira/browse/FLINK-31377, and find another bug.
> which is not fixed completely https://github.com/apache/flink/pull/18967/files
> {code:java}
> SELECT array_contains(ARRAY[CAST(null AS MAP<INT, INT>), MAP[1, 2]], MAP[1, 2]); {code}
> {code:java}
> Caused by: java.lang.UnsupportedOperationException: Unsupported type when convertTypeToSpec: MAP    at org.apache.calcite.sql.type.SqlTypeUtil.convertTypeToSpec(SqlTypeUtil.java:1069)    at org.apache.calcite.sql.type.SqlTypeUtil.convertTypeToSpec(SqlTypeUtil.java:1091)    at org.apache.flink.table.planner.functions.utils.SqlValidatorUtils.castTo(SqlValidatorUtils.java:82)    at org.apache.flink.table.planner.functions.utils.SqlValidatorUtils.adjustTypeForMultisetConstructor(SqlValidatorUtils.java:74)    at org.apache.flink.table.planner.functions.utils.SqlValidatorUtils.adjustTypeForArrayConstructor(SqlValidatorUtils.java:39)    at org.apache.flink.table.planner.functions.sql.SqlArrayConstructor.inferReturnType(SqlArrayConstructor.java:44)    at org.apache.calcite.sql.SqlOperator.validateOperands(SqlOperator.java:504)    at org.apache.calcite.sql.SqlOperator.deriveType(SqlOperator.java:605)    at org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:6218)    at org.apache.calcite.sql.validate.SqlValidatorImpl$DeriveTypeVisitor.visit(SqlValidatorImpl.java:6203)    at org.apache.calcite.sql.SqlCall.accept(SqlCall.java:161)    at org.apache.calcite.sql.validate.SqlValidatorImpl.deriveTypeImpl(SqlValidatorImpl.java:1861)    at org.apache.calcite.sql.validate.SqlValidatorImpl.deriveType(SqlValidatorImpl.java:1852)    at org.apache.flink.table.planner.functions.inference.CallBindingCallContext$1.get(CallBindingCallContext.java:74)    at org.apache.flink.table.planner.functions.inference.CallBindingCallContext$1.get(CallBindingCallContext.java:69)    at org.apache.flink.table.types.inference.strategies.RootArgumentTypeStrategy.inferArgumentType(RootArgumentTypeStrategy.java:58)    at org.apache.flink.table.types.inference.strategies.SequenceInputTypeStrategy.inferInputTypes(SequenceInputTypeStrategy.java:76)    at org.apache.flink.table.planner.functions.inference.TypeInferenceOperandInference.inferOperandTypesOrError(TypeInferenceOperandInference.java:91)    at org.apache.flink.table. {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)