[
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)
