[
https://issues.apache.org/jira/browse/PHOENIX-3388?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Taylor resolved PHOENIX-3388.
-----------------------------------
Resolution: Invalid
Please ask questions on mailing list and make sure to include your DDL
statement.
> Creating a view on phoenix to mapping hbase cannot query successly
> ------------------------------------------------------------------
>
> Key: PHOENIX-3388
> URL: https://issues.apache.org/jira/browse/PHOENIX-3388
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.6.0, 4.8.1
> Environment: Centos x64
> 2.6.32-431.el6.x86_64
> Reporter: dream heaven
>
> I get a compile from phoenix4.8.1 to hbase-cdh5.6.0 by update the code by
> myself.And I try to deploy it to my own test env ,it's also work
> successfully.But I have some program :
> First one is that I need to use " " to create a view for a exists hbase table
> , like this:
> create view "testView" (pk varchar primary key, "info"."c" varchar);
> The second is that when I execute a query,eg.
> select * from "testView" limit 10
> and then , I get the right result ,but when I execute a query with columns
> ,it cannot wok,eg.
> select * from "testView" wsg where PK like "0,1017360,1471364716";
> below is the Exception Stacks:
> org.apache.phoenix.schema.ColumnNotFoundException: ERROR 504 (42703):
> Undefined column. columnName=0,1017360,1471364716
> at org.apache.phoenix.schema.PTableImpl.getColumn(PTableImpl.java:703)
> at
> org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.resolveColumn(FromCompiler.java:451)
> at
> org.apache.phoenix.compile.ExpressionCompiler.resolveColumn(ExpressionCompiler.java:358)
> at
> org.apache.phoenix.compile.WhereCompiler$WhereExpressionCompiler.resolveColumn(WhereCompiler.java:181)
> at
> org.apache.phoenix.compile.WhereCompiler$WhereExpressionCompiler.visit(WhereCompiler.java:169)
> at
> org.apache.phoenix.compile.WhereCompiler$WhereExpressionCompiler.visit(WhereCompiler.java:156)
> at
> org.apache.phoenix.parse.ColumnParseNode.accept(ColumnParseNode.java:56)
> at
> org.apache.phoenix.parse.CompoundParseNode.acceptChildren(CompoundParseNode.java:64)
> at
> org.apache.phoenix.parse.LikeParseNode.accept(LikeParseNode.java:60)
> at
> org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:130)
> at
> org.apache.phoenix.compile.WhereCompiler.compile(WhereCompiler.java:100)
> at
> org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:556)
> at
> org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:507)
> at
> org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:202)
> at
> org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:157)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:406)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:380)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:271)
> at
> org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:266)
> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:265)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1446)
> at sqlline.Commands.execute(Commands.java:822)
> at sqlline.Commands.sql(Commands.java:732)
> at sqlline.SqlLine.dispatch(SqlLine.java:807)
> at sqlline.SqlLine.begin(SqlLine.java:681)
> at sqlline.SqlLine.start(SqlLine.java:398)
> at sqlline.SqlLine.main(SqlLine.java:292)
> By the way,I try to use any colunms ,like "testView".PK,"testView"."PK",'PK'
> and so on ...
> At last ,I try to use java jdbc to get colunms,
> rset.getMetaData().getColumnName(1)
> it return the string "PK".but I cannot use "PK" to get result from resultset..
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
