dream heaven created PHOENIX-3388: ------------------------------------- Summary: 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)