[jira] [Commented] (PHOENIX-2065) Throw TableNotFoundException when select all columns of one column family from the table with schema

["Jun Ng (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-2065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14611444#comment-14611444 ] 

Jun Ng commented on PHOENIX-2065:
---------------------------------

Thomas D'Silva the new patch is still unable to apply ?

> Throw TableNotFoundException when select all columns of one column family from the table with schema
> ----------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-2065
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2065
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.4.0
>            Reporter: Jun Ng
>             Fix For: 4.4.0
>
>         Attachments: PHOENIX-2065-1.patch, PHOENIX-2065-2.patch, PHOENIX-2065-for-4.4-HBase-1.0.patch, PHOENIX-2065-for-master.patch, PHOENIX-2065.patch
>
>
> 1、create table with schema, like "create table s.t (k integer not null primary key, f1.v1 varchar, f2.v2 varchar);"
> 2、select table like "select f1.* from s.t;"
> It goes wrong, throws TableNotFoundException:
> 0: jdbc:phoenix:160.149.0.117> select a.* from dept.saler;
> Error: ERROR 1012 (42M03): Table undefined. tableName=SALER (state=42M03,code=1012)
> org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table undefined. tableName=SALER
>  at org.apache.phoenix.compile.FromCompiler$MultiTableColumnResolver.resolveTable(FromCompiler.java:690)
>  at org.apache.phoenix.compile.FromCompiler$MultiTableColumnResolver.resolveColumnFamily(FromCompiler.java:713)
>  at org.apache.phoenix.compile.FromCompiler$MultiTableColumnResolver.resolveColumn(FromCompiler.java:745)
>  at org.apache.phoenix.compile.FromCompiler$ProjectedTableColumnResolver.resolveColumn(FromCompiler.java:796)
>  at org.apache.phoenix.compile.ProjectionCompiler.projectTableColumnFamily(ProjectionCompiler.java:266)
>  at org.apache.phoenix.compile.ProjectionCompiler.compile(ProjectionCompiler.java:393)
>  at org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:537)
>  at org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:488)
>  at org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:200)
>  at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:157)
>  at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:364)
>  at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:338)
>  at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:246)
>  at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:241)
>  at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>  at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:240)
>  at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1250)
>  at sqlline.Commands.execute(Commands.java:822)
>  at sqlline.Commands.sql(Commands.java:732)
>  at sqlline.SqlLine.dispatch(SqlLine.java:808)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)