Thanks for filing HBASE-568. I just tried it and it looks like its a
bug in HQL for sure.
Here's how it works. The table is offlined and then removed. The
remove is throwing exception so table is left in the offlined state.
FYI, we probably won't fix HBASE-568. We're about to deprecate HQL and
replace it with something else. Will keep the list posted....
St.Ack
Michaela Buergle wrote:
I thought I'd mention that entering
hql > enable titles;
gets everything going again - just in case somebody out there didn't
know yet :)
Does that always work when "region offline" problems occur?
micha
Michaela Buergle wrote:
I have a very simple table named 'titles' that I'm playing around with.
After entering
hql > DELETE * FROM titles;
I get the following output:
08/04/07 15:09:15 INFO hbase.HBaseAdmin: Disabled table titles
Exception in thread "main" java.lang.NullPointerException
at org.apache.hadoop.io.Text.set(Text.java:181)
at org.apache.hadoop.io.Text.<init>(Text.java:76)
at
org.apache.hadoop.hbase.hql.DeleteCommand.getColumnList(DeleteCommand.java:106)
at
org.apache.hadoop.hbase.hql.DeleteCommand.execute(DeleteCommand.java:67)
at
org.apache.hadoop.hbase.hql.HQLClient.executeQuery(HQLClient.java:50)
at org.apache.hadoop.hbase.Shell.main(Shell.java:114)
Every succeeding attempt to query the table results in the following output:
Exception in thread "main" java.lang.IllegalStateException: region
offline: titles,,1207564179189
