[
https://issues.apache.org/jira/browse/CALCITE-2962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16813103#comment-16813103
]
Igor Guzenko commented on CALCITE-2962:
---------------------------------------
Hello [~my7ym] , I also have problem with selection of struct column. While
trying to select column with type STRUCT<name:STRING, age:INT> I'm getting the
stack trace:
{code:java}
Caused by: java.lang.AssertionError: type mismatch:
ref:
VARCHAR(65535) CHARACTER SET "UTF-16LE" COLLATE "UTF-16LE$en_US$primary"
input:
INTEGER
at org.apache.calcite.util.Litmus$1.fail(Litmus.java:31)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at org.apache.calcite.plan.RelOptUtil.eq(RelOptUtil.java:1832)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at org.apache.calcite.rex.RexChecker.visitInputRef(RexChecker.java:125)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at org.apache.calcite.rex.RexChecker.visitInputRef(RexChecker.java:57)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at org.apache.calcite.rex.RexInputRef.accept(RexInputRef.java:112)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at org.apache.calcite.rel.core.Project.isValid(Project.java:186)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at org.apache.calcite.rel.core.Project.<init>(Project.java:83)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at org.apache.calcite.rel.logical.LogicalProject.<init>(LogicalProject.java:62)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at
org.apache.calcite.rel.logical.LogicalProject.create(LogicalProject.java:112)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at
org.apache.calcite.rel.logical.LogicalProject.create(LogicalProject.java:100)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at
org.apache.calcite.rel.core.RelFactories$ProjectFactoryImpl.createProject(RelFactories.java:140)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at org.apache.calcite.tools.RelBuilder.project(RelBuilder.java:1248)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at org.apache.calcite.tools.RelBuilder.projectNamed(RelBuilder.java:1304)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
at
org.apache.calcite.sql2rel.RelStructuredTypeFlattener.rewriteRel(RelStructuredTypeFlattener.java:519)
~[calcite-core-1.18.0-drill-r0.jar:1.18.0-drill-r0]
{code}
So, I tried changes merged for CALCITE-2900, but it didn't work for me. Will
the issue be covered by future PR for the Jira? Also, in case if you don't have
time to fix it, can I assign it to me ?
> RelStructuredTypeFlattener generates wrong types for nested column when
> flattenProjection
> -----------------------------------------------------------------------------------------
>
> Key: CALCITE-2962
> URL: https://issues.apache.org/jira/browse/CALCITE-2962
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.19.0
> Reporter: Will Yu
> Assignee: Will Yu
> Priority: Major
>
> RelStructuredTypeFlattener generates wrong types for nested column when
> flattenProjection. This problem is similar to CALCITE-2900
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
