You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hbase.apache.org by "Michaela Buergle (JIRA)" <ji...@apache.org> on 2008/04/08 09:19:24 UTC
[jira] Created: (HBASE-568) region offline after DELETE
region offline after DELETE
---------------------------
Key: HBASE-568
URL: https://issues.apache.org/jira/browse/HBASE-568
Project: Hadoop HBase
Issue Type: Bug
Components: hql
Reporter: Michaela Buergle
Priority: Minor
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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HBASE-568) region offline after DELETE
Posted by "Andrew Purtell (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HBASE-568?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12592180#action_12592180 ]
Andrew Purtell commented on HBASE-568:
--------------------------------------
This has bitten me as well.
Is there something credible to replace HQL for simple CLI administrative tasks?
> region offline after DELETE
> ---------------------------
>
> Key: HBASE-568
> URL: https://issues.apache.org/jira/browse/HBASE-568
> Project: Hadoop HBase
> Issue Type: Bug
> Components: hql
> Reporter: Michaela Buergle
> Priority: Minor
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (HBASE-568) region offline after DELETE
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HBASE-568?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack resolved HBASE-568.
-------------------------
Resolution: Won't Fix
HQL bug. HQL will be removed for 0.2.0.
> region offline after DELETE
> ---------------------------
>
> Key: HBASE-568
> URL: https://issues.apache.org/jira/browse/HBASE-568
> Project: Hadoop HBase
> Issue Type: Bug
> Components: hql
> Reporter: Michaela Buergle
> Priority: Minor
>
> 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.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.