[jira] Resolved: (HBASE-568) region offline after DELETE

["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.