Phoenix has its own mailing list.
On Fri, Dec 13, 2013 at 9:24 PM, mathan kumar <[email protected]>wrote: > Hi All, > > Created a table (MyTable) in hbase and added data to it and then tried to > access through phoenix client. > > Got exception due to query bug while creating virtual table with the same > name(MyTable). But found that the table got created though exception > occurred. > > Could not access or alter or drop etc on (MyTable) as I get following > > 0: jdbc:phoenix:localhost> drop table "MyTable"; > Error: org.apache.hadoop.hbase.DoNotRetryIOException: ubi_stream_realtime: > 109 (state=08000,code=101) > > 0: jdbc:phoenix:localhost> select * from "MyTable"; > Error: org.apache.hadoop.hbase.DoNotRetryIOException: ubi_stream_realtime: > 109 (state=08000,code=101) > > 0: jdbc:phoenix:localhost> !tables > > +------------+-------------+------------+------------+------------+------------+---------------------------+----------------+-------------+----------------+ > | TABLE_CAT | TABLE_SCHEM | TABLE_NAME | TABLE_TYPE | REMARKS | > TYPE_NAME | SELF_REFERENCING_COL_NAME | REF_GENERATION | INDEX_STATE | > IMMUTABLE_ROWS | > > +------------+-------------+------------+------------+------------+------------+---------------------------+----------------+-------------+----------------+ > | null | SYSTEM | TABLE | SYSTEM TABLE | null | null > | null | null | null | false > | > | null | null | MyTable | TABLE | null | null > | null | null | null | false | > > +------------+-------------+------------+------------+------------+------------+---------------------------+----------------+-------------+----------------+ > > > 0: jdbc:phoenix:localhost> !dropall > Really drop every table in the database? (y/n)abort-drop-all: Aborting drop > all tables.y > Error: ERROR 1012 (42M03): Table undefined. tableName=MyTable > (state=42M03,code=1012) > Aborting command set because "force" is false and command failed: "DROP > TABLE MyTable;" > > > I tried following ways but could not delete the phoenix mapping. > > * Drop table in hbase and tried all queries in phoenix > * Tried rename query in phoenix > * restarted hbase and as well as phoenix client > * recreated same table in phoenix as well as in hbase > > But I could drop the table in HBase using HBase shell and verified that the > table is not listed in HBase after that. > Even now Phoenix could not drop the table and still listing the entry while > using !tables command. > > Where would be the mapping gets stored. Is ter any way to delete the table > entry from phoenix which may / may not be in HBase. > > or else can I map a HBase table with the name "Table1" in HBase to table > name "Table2" in Phoenix or Is ter any way to delete those physical tables > using dfs / hdfs like commands (HBase server is installed in single machine > not as distributed though in my case) > > coz I found that "Table1" name is freezed to the above said errors in > Phoenix though the table is available or not available in HBase. >
