phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alex Batyrshin (Jira)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-5609) Unsupported literal value of type org.apache.phoenix.schema.types.PhoenixArray
Date Mon, 09 Dec 2019 08:37:00 GMT

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

Alex Batyrshin updated PHOENIX-5609:
------------------------------------
    Affects Version/s: 4.14.2
          Description: 
This kind of query doesn't work:


{code:java}
SELECT * FROM table1 WHERE 'test' = ANY(SELECT vararray FROM table2 WHERE pk = 'id' )

java.lang.UnsupportedOperationException: Unsupported literal value [[ARRAY['somedata']]] of
type org.apache.phoenix.schema.types.PhoenixArray at org.apache.phoenix.schema.types.PDataType.fromLiteral(PDataType.java:1178)
at org.apache.phoenix.expression.LiteralExpression.newConstant(LiteralExpression.java:134)
at org.apache.phoenix.expression.LiteralExpression.newConstant(LiteralExpression.java:123)
at org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.java:1327) at org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.java:146)
at org.apache.phoenix.parse.SubqueryParseNode.accept(SubqueryParseNode.java:52) at org.apache.phoenix.parse.CompoundParseNode.acceptChildren(CompoundParseNode.java:64)
at org.apache.phoenix.parse.ArrayAnyComparisonNode.accept(ArrayAnyComparisonNode.java:43)
at org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:138) at org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:108)
at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:229) at org.apache.phoenix.execute.DelegateQueryPlan.iterator(DelegateQueryPlan.java:144)
at org.apache.phoenix.execute.DelegateQueryPlan.iterator(DelegateQueryPlan.java:139) at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:312)
at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:291) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:290) at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:283)
at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1830) at sqlline.Commands.execute(Commands.java:822)
at sqlline.Commands.sql(Commands.java:732) at sqlline.SqlLine.dispatch(SqlLine.java:813) at
sqlline.SqlLine.begin(SqlLine.java:686) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291){code}
              Summary: Unsupported literal value of type org.apache.phoenix.schema.types.PhoenixArray
 (was: select from )

> Unsupported literal value of type org.apache.phoenix.schema.types.PhoenixArray
> ------------------------------------------------------------------------------
>
>                 Key: PHOENIX-5609
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-5609
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.14.2
>            Reporter: Alex Batyrshin
>            Priority: Major
>
> This kind of query doesn't work:
> {code:java}
> SELECT * FROM table1 WHERE 'test' = ANY(SELECT vararray FROM table2 WHERE pk = 'id' )
> java.lang.UnsupportedOperationException: Unsupported literal value [[ARRAY['somedata']]]
of type org.apache.phoenix.schema.types.PhoenixArray at org.apache.phoenix.schema.types.PDataType.fromLiteral(PDataType.java:1178)
at org.apache.phoenix.expression.LiteralExpression.newConstant(LiteralExpression.java:134)
at org.apache.phoenix.expression.LiteralExpression.newConstant(LiteralExpression.java:123)
at org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.java:1327) at org.apache.phoenix.compile.ExpressionCompiler.visit(ExpressionCompiler.java:146)
at org.apache.phoenix.parse.SubqueryParseNode.accept(SubqueryParseNode.java:52) at org.apache.phoenix.parse.CompoundParseNode.acceptChildren(CompoundParseNode.java:64)
at org.apache.phoenix.parse.ArrayAnyComparisonNode.accept(ArrayAnyComparisonNode.java:43)
at org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:138) at org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:108)
at org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:229) at org.apache.phoenix.execute.DelegateQueryPlan.iterator(DelegateQueryPlan.java:144)
at org.apache.phoenix.execute.DelegateQueryPlan.iterator(DelegateQueryPlan.java:139) at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:312)
at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:291) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:290) at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:283)
at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1830) at sqlline.Commands.execute(Commands.java:822)
at sqlline.Commands.sql(Commands.java:732) at sqlline.SqlLine.dispatch(SqlLine.java:813) at
sqlline.SqlLine.begin(SqlLine.java:686) at sqlline.SqlLine.start(SqlLine.java:398) at sqlline.SqlLine.main(SqlLine.java:291){code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message