You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Alex Batyrshin (Jira)" <ji...@apache.org> on 2019/12/09 08:37:00 UTC
[jira] [Updated] (PHOENIX-5609) Unsupported literal value of type
org.apache.phoenix.schema.types.PhoenixArray
[ 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)