You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-dev@hadoop.apache.org by "Edward Yoon (JIRA)" <ji...@apache.org> on 2007/12/04 00:45:43 UTC
[jira] Created: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
[Hbase Shell] Delete command with no WHERE clause
-------------------------------------------------
Key: HADOOP-2339
URL: https://issues.apache.org/jira/browse/HADOOP-2339
Project: Hadoop
Issue Type: Improvement
Components: contrib/hbase
Affects Versions: 0.16.0
Reporter: Edward Yoon
Assignee: Edward Yoon
Fix For: 0.16.0
using HbaseAdmin.deleteColumn() method.
{code}
DELETE column_name FROM table_name;
{code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Bryan Duxbury (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Duxbury updated HADOOP-2339:
----------------------------------
Priority: Minor (was: Major)
Not a major issue, but should still be looked at.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Priority: Minor
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Status: Open (was: Patch Available)
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548102 ]
stack commented on HADOOP-2339:
-------------------------------
One question: What happens if user specifies a column name that is not a column family? I suppose in this case we should delete all cells for the specified column? Also, I wonder if 'delete b: from udanax' shouldn't just delete column content rather than actual column itself: i.e. disable, remove, readd, re-enable?
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12553688 ]
Edward Yoon commented on HADOOP-2339:
-------------------------------------
Anyhow, Should it be closed?
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Priority: Minor
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12550736 ]
Edward Yoon commented on HADOOP-2339:
-------------------------------------
'columnfamily', 'columnfamily:specified_qualifer' delete function is important thing.
I'm not bothering to make a example.
Also, I thought it should be work as inter-row wise partitioned sub structre parallelism.
But, now shell is 0.0.1 version.
Imagine the processing-speed:increment by row-count:increment 2d plots of scanner and mapreduce,
start points of processing-speed dimension and slopes will be different.
So, I thought the cross point find algorithm for the most faster automatical processing.
'Slow Performance' can't touch the grammar rules.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Status: Patch Available (was: In Progress)
submitting.
I'd like to commit to 0.16 TRUNK.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548073 ]
Edward Yoon commented on HADOOP-2339:
-------------------------------------
{code}
DELETE * FROM table_name;
{code}
NOTE: Now just using deleteColumn() method in a loop.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548135 ]
Edward Yoon commented on HADOOP-2339:
-------------------------------------
{code}
DROP COLUMNFAMILY columnfamily_name1[, columnfamily_name2, ...] FROM table_name;
{code}
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Issue Comment Edited: (HADOOP-2339) [Hbase Shell] Delete
command with no WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548133 ]
udanax edited comment on HADOOP-2339 at 12/3/07 9:25 PM:
--------------------------------------------------------------
ugh... It seems troublesome...
*hql > DELETE columnA: FROM table;*
In this case, only "columnA:" should be deleted.
{code}
Row1 columnA: ----> to be deleted
columnA:a
columnA:b
Row2 columnA: ----> to be deleted
columnA:b
columnA:c
{code}
....
And then, how can i delete all columns in columnfamily?
I'd like to use the deleteColumn() method to drop the *ColumnFamily*
{code}
DROP TABLE table_name;
DROP COLUMNFAMILY columnfamily_name;
{code}
was (Author: udanax):
ugh... It seems troublesome...
*hql > DELETE columnA: FROM table;*
In this case, only "columnA:" should be deleted.
{code}
columnA: ----> to be deleted
columnA:a
columnA:b
{code}
....
And then, how can i delete all columns in columnfamily?
I'd like to use the deleteColumn() method to drop the *ColumnFamily*
{code}
DROP TABLE table_name;
DROP COLUMNFAMILY columnfamily_name;
{code}
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Work started: (HADOOP-2339) [Hbase Shell] Delete command
with no WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Work on HADOOP-2339 started by Edward Yoon.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Status: Patch Available (was: Open)
Re-try
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Bryan Duxbury (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548871 ]
Bryan Duxbury commented on HADOOP-2339:
---------------------------------------
To clarify this issue, are we talking about what is essentially an ALTER TABLE DROP COLUMN in SQL? If so, the description should be changed to reflect that.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "stack (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
stack updated HADOOP-2339:
--------------------------
Resolution: Fixed
Status: Resolved (was: Patch Available)
Committed. Resolving. Thanks Edward.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Attachment: 2339.patch
{code}
hql > select * from udanax;
+-------------------------+-------------------------+-------------------------+
| Row | Column | Cell |
+-------------------------+-------------------------+-------------------------+
| row1 | a: | aa |
+-------------------------+-------------------------+-------------------------+
| row1 | b: | aa |
+-------------------------+-------------------------+-------------------------+
| row2 | b: | aa |
+-------------------------+-------------------------+-------------------------+
3 row(s) in set. (0.06 sec)
hql > delete b: from udanax;
07/12/04 09:30:15 INFO hbase.HBaseAdmin: Disabled table udanax
07/12/04 09:30:15 INFO hbase.HBaseAdmin: Enabled table udanax
Column(s) deleted successfully. (10.16 sec)
hql > select * from udanax;
+-------------------------+-------------------------+-------------------------+
| Row | Column | Cell |
+-------------------------+-------------------------+-------------------------+
| row1 | a: | aa |
+-------------------------+-------------------------+-------------------------+
1 row(s) in set. (0.05 sec)
hql >
{code}
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Status: Patch Available (was: Open)
resubmitting
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Priority: Minor
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Attachment: 2339_v03.patch
Sorry, wrong spell was fixed. (dropped -> deleted)
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Status: Patch Available (was: Open)
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12552797 ]
Edward Yoon commented on HADOOP-2339:
-------------------------------------
Bryan, I removed your comments because there is no messages.
If you have a constructive comment, please share it.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Priority: Minor
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548242 ]
Hudson commented on HADOOP-2339:
--------------------------------
Integrated in Hadoop-Nightly #322 (See [http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Nightly/322/])
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Issue Comment Edited: (HADOOP-2339) [Hbase Shell] Delete
command with no WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12552598 ]
udanax edited comment on HADOOP-2339 at 12/17/07 5:37 PM:
---------------------------------------------------------------
Let's assume the webtable (bigtable paper)
{code}
url<row> content anchor language metatag ...
http://abcd.com ... anchor:http://xyz.com <xyz dot com> ... ...
anchor:http://udanax.org <udanax homepage>
{code}
At this time, 'udanax.org' was evaporation from the world-wide-web.
Then we need to delete the 'anchor:http://udanax.org' of all rows for transformation of url by anchor (inlink by outlink).
was (Author: udanax):
Let's assume the webtable (bigtable paper)
{code}
url<row> content anchor language metatag ...
http://abcd.com ... anchor:http://xyz.com <xyz dot com> ... ...
anchor:http://udanax.org <udanax homepage>
{code}
At this time, 'udanax.org' was evaporation from the world-wide-web.
Then we need to delete the 'anchor:http://udanax.org' of all rows.
I think this method is formal, useful, basical method.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Issue Comment Edited: (HADOOP-2339) [Hbase Shell] Delete
command with no WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12550736 ]
udanax edited comment on HADOOP-2339 at 12/11/07 3:08 PM:
---------------------------------------------------------------
'columnfamily', 'columnfamily:specified_qualifer' delete function is important thing.
I'm not bothering to make a example.
Also, I thought it should be work as inter-row wise partitioned sub structre parallelism.
But, now shell is 0.0.1 version.
Imagine the processing-speed:increment by row-count:increment 2d plots of scanner and mapreduce,
start points of processing-speed dimension and slopes will be different.
So, I thought the cross point find algorithm for the most faster automatical processing.
'Slow Performance' -can't- should not touch the grammar rules.
was (Author: udanax):
'columnfamily', 'columnfamily:specified_qualifer' delete function is important thing.
I'm not bothering to make a example.
Also, I thought it should be work as inter-row wise partitioned sub structre parallelism.
But, now shell is 0.0.1 version.
Imagine the processing-speed:increment by row-count:increment 2d plots of scanner and mapreduce,
start points of processing-speed dimension and slopes will be different.
So, I thought the cross point find algorithm for the most faster automatical processing.
'Slow Performance' can't touch the grammar rules.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Attachment: 2339_v02.patch
Ok. Drop has a different mean.
So,...
column_name1[, column_name2, ...] or COLUMNFAMILIES(column1[, column2])
ex.
DELETE column:, column:a, column:b FROM table; // delete the specified columns
DELETE COLUMNFAMILIES(column1, column2) FROM table; // delete the columnfamilies
DELETE * FROM table;
{code}
hql > select * from udanax;
+-------------------------+-------------------------+-------------------------+
| Row | Column | Cell |
+-------------------------+-------------------------+-------------------------+
| a | b: | bb3 |
+-------------------------+-------------------------+-------------------------+
| a | c: | cc |
+-------------------------+-------------------------+-------------------------+
| b | b: | bb2 |
+-------------------------+-------------------------+-------------------------+
| b | c: | cc2 |
+-------------------------+-------------------------+-------------------------+
| c | b:aa | aa |
+-------------------------+-------------------------+-------------------------+
| c | c: | bb |
+-------------------------+-------------------------+-------------------------+
6 row(s) in set. (0.06 sec)
hql > delete 'b:aa' from udanax;
1 Column(s) deleted successfully. (0.03 sec)
hql > select * from udanax;
+-------------------------+-------------------------+-------------------------+
| Row | Column | Cell |
+-------------------------+-------------------------+-------------------------+
| a | b: | bb3 |
+-------------------------+-------------------------+-------------------------+
| a | c: | cc |
+-------------------------+-------------------------+-------------------------+
| b | b: | bb2 |
+-------------------------+-------------------------+-------------------------+
| b | c: | cc2 |
+-------------------------+-------------------------+-------------------------+
| c | c: | bb |
+-------------------------+-------------------------+-------------------------+
5 row(s) in set. (0.06 sec)
hql > delete columnfamilies(c) from udanax;
delete columnfamilies(c) from udanax;
Dropping c:... Please wait.
07/12/04 16:36:38 INFO hbase.HBaseAdmin: Disabled table udanax
07/12/04 16:36:38 INFO hbase.HBaseAdmin: Enabled table udanax
1 columnfamily(s) deleted successfully. (10.12 sec)
hql > select * from udanax;
select * from udanax;
+-------------------------+-------------------------+-------------------------+
| Row | Column | Cell |
+-------------------------+-------------------------+-------------------------+
| a | b: | bb3 |
+-------------------------+-------------------------+-------------------------+
| b | b: | bb2 |
+-------------------------+-------------------------+-------------------------+
2 row(s) in set. (0.07 sec)
hql >
{code}
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Bryan Duxbury (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12551879 ]
Bryan Duxbury commented on HADOOP-2339:
---------------------------------------
Edward - Can you clarify your comment above? Maybe it's just a language thing, but I really don't understand your argument for the functionality.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Priority: Minor (was: Major)
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Priority: Minor
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548640 ]
Hadoop QA commented on HADOOP-2339:
-----------------------------------
-1 overall. Here are the results of testing the latest attachment
http://issues.apache.org/jira/secure/attachment/12370926/2339_v04.patch
against trunk revision r601232.
@author +1. The patch does not contain any @author tags.
javadoc +1. The javadoc tool did not generate any warning messages.
javac +1. The applied patch does not generate any new compiler warnings.
findbugs +1. The patch does not introduce any new Findbugs warnings.
core tests +1. The patch passed core unit tests.
contrib tests -1. The patch failed contrib unit tests.
Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1270/testReport/
Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1270/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1270/artifact/trunk/build/test/checkstyle-errors.html
Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1270/console
This message is automatically generated.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12550322 ]
Hadoop QA commented on HADOOP-2339:
-----------------------------------
+1 overall. Here are the results of testing the latest attachment
http://issues.apache.org/jira/secure/attachment/12370926/2339_v04.patch
against trunk revision r603084.
@author +1. The patch does not contain any @author tags.
javadoc +1. The javadoc tool did not generate any warning messages.
javac +1. The applied patch does not generate any new compiler warnings.
findbugs +1. The patch does not introduce any new Findbugs warnings.
core tests +1. The patch passed core unit tests.
contrib tests +1. The patch passed contrib unit tests.
Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1314/testReport/
Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1314/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1314/artifact/trunk/build/test/checkstyle-errors.html
Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1314/console
This message is automatically generated.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Priority: Minor
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548093 ]
Hadoop QA commented on HADOOP-2339:
-----------------------------------
+1 overall. Here are the results of testing the latest attachment
http://issues.apache.org/jira/secure/attachment/12370898/2339.patch
against trunk revision r600707.
@author +1. The patch does not contain any @author tags.
javadoc +1. The javadoc tool did not generate any warning messages.
javac +1. The applied patch does not generate any new compiler warnings.
findbugs +1. The patch does not introduce any new Findbugs warnings.
core tests +1. The patch passed core unit tests.
contrib tests +1. The patch passed contrib unit tests.
Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1250/testReport/
Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1250/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1250/artifact/trunk/build/test/checkstyle-errors.html
Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1250/console
This message is automatically generated.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon reopened HADOOP-2339:
---------------------------------
Ah... Sorry for my carelessness.
I'll attach the patch for describe below.
{code}
DELETE column_name:qualifier_name FROM table_name;
{code}
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Status: Patch Available (was: Open)
Re-trying after 2333 comitted.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Priority: Major (was: Minor)
Now DELETE statement has a serious logical error,
It should be fixed, and I think it is a important thing.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Status: Open (was: Patch Available)
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Bryan Duxbury (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12550773 ]
Bryan Duxbury commented on HADOOP-2339:
---------------------------------------
@Edward: I have no idea what you are talking about.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Status: Open (was: Patch Available)
Canceling because QA returns -1
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Status: Patch Available (was: Reopened)
Ok, submitting.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Comment: was deleted
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Priority: Minor
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Status: Open (was: Patch Available)
canceling
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Priority: Minor
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548177 ]
Hadoop QA commented on HADOOP-2339:
-----------------------------------
-1 overall. Here are the results of testing the latest attachment
http://issues.apache.org/jira/secure/attachment/12370921/2339_v03.patch
against trunk revision r600771.
@author +1. The patch does not contain any @author tags.
javadoc +1. The javadoc tool did not generate any warning messages.
javac +1. The applied patch does not generate any new compiler warnings.
findbugs +1. The patch does not introduce any new Findbugs warnings.
core tests +1. The patch passed core unit tests.
contrib tests -1. The patch failed contrib unit tests.
Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1255/testReport/
Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1255/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1255/artifact/trunk/build/test/checkstyle-errors.html
Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1255/console
This message is automatically generated.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548256 ]
Hadoop QA commented on HADOOP-2339:
-----------------------------------
-1 overall. Here are the results of testing the latest attachment
http://issues.apache.org/jira/secure/attachment/12370926/2339_v04.patch
against trunk revision r600771.
@author +1. The patch does not contain any @author tags.
javadoc +1. The javadoc tool did not generate any warning messages.
javac +1. The applied patch does not generate any new compiler warnings.
findbugs +1. The patch does not introduce any new Findbugs warnings.
core tests +1. The patch passed core unit tests.
contrib tests -1. The patch failed contrib unit tests.
Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1257/testReport/
Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1257/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1257/artifact/trunk/build/test/checkstyle-errors.html
Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1257/console
This message is automatically generated.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon reassigned HADOOP-2339:
-----------------------------------
Assignee: stack (was: Edward Yoon)
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: stack
> Priority: Minor
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Bryan Duxbury (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12550676 ]
Bryan Duxbury commented on HADOOP-2339:
---------------------------------------
Let's specify very clearly what this issue regards.
As I understand it, the goal is to be able to delete a specific column family and qualifier on every row in the entire table. It's important to note that the qualifier is needed, because you can already do this essentially with ALTER TABLE if you want to delete an entire column family. Is this correct?
If so, I'm not sure that we should offer this functionality. It will be slow, especially if it's run as a single delete at a time in serial from the shell. I would think that from the shell, you have the ability to empty an entire table with TRUNCATE, or delete an entire column family with ALTER TABLE ... DROP columnfamily, and that's probably enough. If you actually do need to delete just a given qualified column name on every row in your table, you should write a mapreduce job or some other highly parallel way to do that. This is in keeping with the goal of making the shell both efficient and lean when it comes to the functionality it supports.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Hadoop QA (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548205 ]
Hadoop QA commented on HADOOP-2339:
-----------------------------------
-1 overall. Here are the results of testing the latest attachment
http://issues.apache.org/jira/secure/attachment/12370926/2339_v04.patch
against trunk revision r600771.
@author +1. The patch does not contain any @author tags.
javadoc +1. The javadoc tool did not generate any warning messages.
javac +1. The applied patch does not generate any new compiler warnings.
findbugs +1. The patch does not introduce any new Findbugs warnings.
core tests +1. The patch passed core unit tests.
contrib tests -1. The patch failed contrib unit tests.
Test results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1256/testReport/
Findbugs warnings: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1256/artifact/trunk/build/test/findbugs/newPatchFindbugsWarnings.html
Checkstyle results: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1256/artifact/trunk/build/test/checkstyle-errors.html
Console output: http://lucene.zones.apache.org:8080/hudson/job/Hadoop-Patch/1256/console
This message is automatically generated.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Jim Kellerman (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jim Kellerman updated HADOOP-2339:
----------------------------------
Fix Version/s: (was: 0.16.0)
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop Core
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: stack
> Priority: Minor
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12552598 ]
Edward Yoon commented on HADOOP-2339:
-------------------------------------
Let's assume the webtable (bigtable paper)
{code}
url<row> content anchor language metatag ...
http://abcd.com ... anchor:http://xyz.com <xyz dot com> ... ...
anchor:http://udanax.org <udanax homepage>
{code}
At this time, 'udanax.org' was evaporation from the world-wide-web.
Then we need to delete the 'anchor:http://udanax.org' of all rows.
I think this method is formal, useful, basical method.
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (HADOOP-2339) [Hbase Shell] Delete command with
no WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548133 ]
Edward Yoon commented on HADOOP-2339:
-------------------------------------
ugh... It seems troublesome...
*hql > DELETE columnA: FROM table;*
In this case, only "columnA:" should be deleted.
{code}
columnA: ----> to be deleted
columnA:a
columnA:b
{code}
....
And then, how can i delete all columns in columnfamily?
I'd like to use the deleteColumn() method to drop the *ColumnFamily*
{code}
DROP TABLE table_name;
DROP COLUMNFAMILY columnfamily_name;
{code}
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (HADOOP-2339) [Hbase Shell] Delete command with no
WHERE clause
Posted by "Edward Yoon (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HADOOP-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Edward Yoon updated HADOOP-2339:
--------------------------------
Attachment: 2339_v04.patch
Local test passed.
So, re-submitting.
{code}
test:
[echo] contrib: hbase
[delete] Deleting directory /root/workspace/hadoop/build/contrib/hbase/test/logs
[mkdir] Created dir: /root/workspace/hadoop/build/contrib/hbase/test/logs
[junit] Running org.apache.hadoop.hbase.shell.TestHBaseShell
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 52.787 sec
[junit] Running org.apache.hadoop.hbase.shell.TestSubstitutionVariables
[junit] Tests run: 2, Failures: 0, Errors: 0, Time elapsed: 0.019 sec
[junit] Running org.apache.hadoop.hbase.shell.algebra.TestBooleanCondition
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.044 sec
[junit] Running org.apache.hadoop.hbase.shell.algebra.TestBooleanTermFilter
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 23.241 sec
[junit] Running org.apache.hadoop.hbase.shell.algebra.TestJoinCondition
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.158 sec
[junit] Running org.apache.hadoop.hbase.shell.algebra.TestTableJoinMapReduce [junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 87.233 sec
[junit] Running org.apache.hadoop.hbase.util.TestBase64
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.136 sec
[junit] Running org.apache.hadoop.hbase.util.TestKeying
[junit] Tests run: 1, Failures: 0, Errors: 0, Time elapsed: 0.011 sec
[junit] Running org.onelab.test.TestFilter
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 0.025 sec
BUILD SUCCESSFUL
Total time: 2 minutes 54 seconds
bash-3.00#
{code}
> [Hbase Shell] Delete command with no WHERE clause
> -------------------------------------------------
>
> Key: HADOOP-2339
> URL: https://issues.apache.org/jira/browse/HADOOP-2339
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.16.0
> Reporter: Edward Yoon
> Assignee: Edward Yoon
> Fix For: 0.16.0
>
> Attachments: 2339.patch, 2339_v02.patch, 2339_v03.patch, 2339_v04.patch
>
>
> using HbaseAdmin.deleteColumn() method.
> {code}
> DELETE column_name FROM table_name;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.