Hi Vamshi, Phoenix is a layer on HBase and only sees tables that have been defined for Phoenix using DDL, those tables have entries in the SYSTEM.CATALOG table. Using !tables is a query against that table.
HBase sees all tables. -chris > On Jul 31, 2015, at 2:25 AM, Vamshi Krishna <vamshi2...@gmail.com> wrote: > > The interesting thing is, if a table is created using phoenix, they are > seen inside hbase shell. But, if a table is created using hbase shell, they > are not seen using phoenix command line interface. I use ./sqlline.py > localshost where hbase is running in psuedo distributed mode with > zookeepr at 2181. > I am trying to see the list of tables on phoenix with command : !tables , > Is it right or something am i missing? > > > Why is this unexpected behavior? > > On Fri, Jul 31, 2015 at 1:10 PM, Vamshi Krishna <vamshi2...@gmail.com> > wrote: > >> 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* > > > > -- > *Regards* > > > *Vamshi Krishna*
