hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mathan kumar <immathanku...@gmail.com>
Subject Re: Undefined table and DoNotRetryIOException errors when accessed from phoenix
Date Sat, 14 Dec 2013 06:46:48 GMT
sent to Phoenix mailing list and got the reply to check with HBase users


On Sat, Dec 14, 2013 at 10:59 AM, Ted Yu <yuzhihong@gmail.com> wrote:

> Phoenix has its own mailing list.
>
>
> On Fri, Dec 13, 2013 at 9:24 PM, mathan kumar <immathankumar@gmail.com
> >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.
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message