hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Duxbury <br...@rapleaf.com>
Subject Re: region offline after DELETE
Date Mon, 07 Apr 2008 17:13:30 GMT
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


Mime
View raw message