Whatever you have mentioned is correct. Thank you. But. when i do !tables, already existing tables that were created before phoenix installed should also be seen right ? Those tables are not seen here. And moreover, when i create tables in hbase, i don't use any schema explicity such as 'stats' or 'system'.
On Thu, Jul 30, 2015 at 9:40 PM, Ravi Kiran <maghamraviki...@gmail.com> wrote: > 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* > > > -- *Regards* *Vamshi Krishna*
