phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "qihuang.zheng"<qihuang.zh...@fraudmetrix.cn>
Subject table create in hbase shell invisable on phoenix
Date Wed, 16 Dec 2015 13:22:49 GMT
I’m newbie to phoenix, I create test.table in hbase shell, but in phoenix sqlline can’t
see it. But vice versa when create table in phoenix, I can see it on hbase shell. Do I missing
sth?
hbase(main):008:0* create 'test.table','cf' = Hbase::Table - test.table hbase(main):009:0
list TABLE SYSTEM.CATALOG SYSTEM.FUNCTION SYSTEM.SEQUENCE SYSTEM.STATS TEST.PERSON table test.table
7 row(s) in 0.0200 seconds = ["SYSTEM.CATALOG", "SYSTEM.FUNCTION", "SYSTEM.SEQUENCE", "SYSTEM.STATS",
"TEST.PERSON", "table", "test.table"]
the tabletest.personwas create by phoenix below, and it's visable in hbase shell as you can
see above
when query phoenix, I just can't see test.table which create by hbase shell.
0: jdbc:phoenix:192.168.47.83,192.168.47.84,1 !table +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------+
| TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARK | +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------+
| | SYSTEM | CATALOG | SYSTEM TABLE | | | | SYSTEM | FUNCTION | SYSTEM TABLE | | | | SYSTEM
| SEQUENCE | SYSTEM TABLE | | | | SYSTEM | STATS | SYSTEM TABLE | | | | TEST | PERSON | TABLE
| | +------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------+




tks, qihuang.zheng
Mime
View raw message