[
https://issues.apache.org/jira/browse/HADOOP-1608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12533269
]
Edward Yoon commented on HADOOP-1608:
-------------------------------------
I remove limitation.
{code}
Hbase> Relation = table('movieLog_table');
Hbase> Result = Relation.selection(length > 100);
Hbase> save Result into table('result');
Job job_local_1 is still running..
Successfully complete.
Hbase> select * from result;
+-------------------------+-------------------------+-------------------------+
| Row | Column | Cell |
+-------------------------+-------------------------+-------------------------+
| Mighty Ducks | inColor: | true |
+-------------------------+-------------------------+-------------------------+
| Mighty Ducks | length: | 142 |
+-------------------------+-------------------------+-------------------------+
| Mighty Ducks | producer: | Blair Peters |
+-------------------------+-------------------------+-------------------------+
| Mighty Ducks | studioName: | Disney |
+-------------------------+-------------------------+-------------------------+
| Mighty Ducks | vote:user 0 | 2 |
+-------------------------+-------------------------+-------------------------+
| Mighty Ducks | year: | 1991 |
+-------------------------+-------------------------+-------------------------+
| Star Wars | inColor: | true |
+-------------------------+-------------------------+-------------------------+
| Star Wars | length: | 124 |
+-------------------------+-------------------------+-------------------------+
| Star Wars | producer: | George Lucas |
+-------------------------+-------------------------+-------------------------+
| Star Wars | studioName: | Fox |
+-------------------------+-------------------------+-------------------------+
| Star Wars | vote:user | 5 |
+-------------------------+-------------------------+-------------------------+
| Star Wars | vote:user 0 | 2 |
+-------------------------+-------------------------+-------------------------+
| Star Wars | year: | 1977 |
+-------------------------+-------------------------+-------------------------+
13 row(s) in set (0.04 sec)
{code}
> [HbaseShell] Relational Algrebra Operators
> ------------------------------------------
>
> Key: HADOOP-1608
> URL: https://issues.apache.org/jira/browse/HADOOP-1608
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Environment: All environments
> Reporter: Edward Yoon
> Priority: Minor
> Fix For: 0.16.0
>
> Attachments: patch_v01.txt, patch_v02.txt, patch_v03.txt,
> patch_v04.txt, patch_v05.txt, patch_v06.txt
>
>
> Development of relational algebra operators has begun.
> * Projection
> ** selects a subset of the columnfamilies of a relation
> ** Result = π ~column_list~ (Relation)
> {code}
> Hbase > Result = Relation.Projection('year','legnth');
> Hbase > save Result into table('result');
> {code}
> * Selection
> ** See : HADOOP-2003 issue's description
> {code}
> Hbase> Result = Relation.Selection(length > 100 and studioName = 'Fox');
> Hbase> save Result into table('result');
> {code}
> * Product
> * Rename
> * Group
> * Sort
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
