Hi Vamsi, Please give the full table name in select. SELECT * FROM STATS.PROD_METRICS;
Regards Ravi On Thu, Jul 30, 2015 at 6:33 AM, Vamshi Krishna <vamshi2...@gmail.com> wrote: > Hi, > I am trying to access my hbase running on my local machine with zookeeper > at localhost:2181. I installed phoenix-3.3.1-bin and trying to access an > already existing hbase tabe, but could not. So, simply to test, i created a > table using phoenix commandline and see it when i run !tables command. but > when i run selet command, it shows error. > > > This is what I am doing. > > 0: jdbc:phoenix:localhost> CREATE TABLE stats.prod_metrics ( host char(50) > not null, created_date date not null, > > . . . . . . . . . . . . .> txn_count bigint CONSTRAINT pk PRIMARY KEY > (host, created_date) ); > > No rows affected (1.82 seconds) > > 0: jdbc:phoenix:localhost> !tables > > > *+------------------------------------------+------------------------------------------+------------------------------------------+---------------------------+* > > *| ** TABLE_CAT ** | ** > TABLE_SCHEM ** | ** TABLE_NAME ** > | ** TABLE_TYPE** |* > > > *+------------------------------------------+------------------------------------------+------------------------------------------+---------------------------+* > > *| * * | *SYSTEM > * | *CATALOG * | *SYSTEM > TABLE * |* > > *| * * | *SYSTEM > * | *SEQUENCE * | *SYSTEM > TABLE * |* > > *| * * | *SYSTEM > * | *STATS * | *SYSTEM > TABLE * |* > > *| * * | *STATS > * | *PROD_METRICS * | *TABLE > * |* > > > *+------------------------------------------+------------------------------------------+------------------------------------------+---------------------------+* > > 0: jdbc:phoenix:localhost> select * from PROD_METRICS; > > *Error: ERROR 1012 (42M03): Table undefined. tableName=PROD_METRICS > (state=42M03,code=1012)* > > org.apache.phoenix.schema.TableNotFoundException: ERROR 1012 (42M03): Table > undefined. tableName=PROD_METRICS > > at > > org.apache.phoenix.compile.FromCompiler$BaseColumnResolver.createTableRef(FromCompiler.java:336) > > at > > org.apache.phoenix.compile.FromCompiler$SingleTableColumnResolver.<init>(FromCompiler.java:236) > > at > > org.apache.phoenix.compile.FromCompiler.getResolverForQuery(FromCompiler.java:159) > > at > > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:318) > > at > > org.apache.phoenix.jdbc.PhoenixStatement$ExecutableSelectStatement.compilePlan(PhoenixStatement.java:308) > > at > org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:225) > > at > org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:221) > > at > > org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:54) > > at > > org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:221) > > at > > org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1059) > > at sqlline.Commands.execute(Commands.java:822) > > at sqlline.Commands.sql(Commands.java:732) > > at sqlline.SqlLine.dispatch(SqlLine.java:808) > > at sqlline.SqlLine.begin(SqlLine.java:681) > > at sqlline.SqlLine.start(SqlLine.java:398) > > at sqlline.SqlLine.main(SqlLine.java:292) > > 0: jdbc:phoenix:localhost> !tables > > > *+------------------------------------------+------------------------------------------+------------------------------------------+---------------------------+* > > *| ** TABLE_CAT ** | ** > TABLE_SCHEM ** | ** TABLE_NAME ** > | ** TABLE_TYPE** |* > > > *+------------------------------------------+------------------------------------------+------------------------------------------+---------------------------+* > > *| * * | *SYSTEM > * | *CATALOG * | *SYSTEM > TABLE * |* > > *| * * | *SYSTEM > * | *SEQUENCE * | *SYSTEM > TABLE * |* > > *| * * | *SYSTEM > * | *STATS * | *SYSTEM > TABLE * |* > > *| * * | *STATS > * | *PROD_METRICS * | *TABLE > * |* > > > *+------------------------------------------+------------------------------------------+------------------------------------------+---------------------------+* > > > Can any one help?? > > > > > -- > *Regards* > > > *Vamshi* >
