yes,I have met the same problem.
On Tue, Apr 8, 2008 at 1:13 AM, Bryan Duxbury <[EMAIL PROTECTED]> wrote: > Looks like an HQL bug to me. Would you mind filing a ticket with the > contents of this email? > > -Bryan > > > > On Apr 7, 2008, at 9:59 AM, Michaela Buergle wrote: > > > > Hi there, > > I have made first contact with "region offline". As I've seen that topic > > mentioned in some of the devel-threads I thought I'd just report what > > happened in my case (using hadoop 0.16.1 and hbase 0.1.0 on two nodes): > > > > 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 > > at > > > org.apache.hadoop.hbase.HConnectionManager$TableServers.locateRegionInMeta(HConnectionManager.java:438) > > at > > > org.apache.hadoop.hbase.HConnectionManager$TableServers.locateRegion(HConnectionManager.java:350) > > at > > > org.apache.hadoop.hbase.HConnectionManager$TableServers.locateRegion(HConnectionManager.java:313) > > at org.apache.hadoop.hbase.HTable.<init>(HTable.java:91) > > at > > org.apache.hadoop.hbase.hql.SelectCommand.execute(SelectCommand.java:90) > > at > > org.apache.hadoop.hbase.hql.HQLClient.executeQuery(HQLClient.java:50) > > at org.apache.hadoop.hbase.Shell.main(Shell.java:114) > > > > > > Deleting a specific column on the other hand, as in: > > > > hql> DELETE document:title FROM titles; > > > > is no problem - I get this output: > > > > 08/04/07 17:08:02 INFO hbase.HBaseAdmin: Disabled table titles > > 08/04/07 17:08:02 INFO hbase.HBaseAdmin: Enabled table titles > > > > and everything's all right ever after. > > > > Best regards, > > Micha > > > >
