hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ma qiang" <maqiang1...@gmail.com>
Subject Re: region offline after DELETE
Date Tue, 08 Apr 2008 02:14:55 GMT
yes,I have met the same problem.

On Tue, Apr 8, 2008 at 1:13 AM, Bryan Duxbury <bryan@rapleaf.com> 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
> >
>
>

Mime
View raw message