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
