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*
