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