[
https://issues.apache.org/jira/browse/HADOOP-1608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
edward yoon updated HADOOP-1608:
--------------------------------
Attachment: shell_v02.patch
This patch
* adds (project, select, sort, substitute, store) command.
{code}
Examples.
HBase > A = table('movieLog_table');
HBase > B = A.projection('year','length');
HBase > [C = sort B by ('year');]
HBase > store B to table('temp_table');
...
HBase > A = table('movieLog_table');
HBase > B = A.selection(length > 100);
HBase > store B to table('temp_table2');
...
HBase > A = table('movieLog_table');
HBase > B = A.projection('year','length','studioName');
HBase > C = B.selection(length > 100);
HBase > D = sort C by ('studioName');
HBase > store D to table('temp_table3');
--Output Table Creating.
--Job 'job_200707200959_0003' is submitted
--Job job_200707200959_0003 is still running.
--Job job_200707200959_0003 is still running.
--Job job_200707200959_0003 is still running.
Job Successful.(47.86 sec)
HBase > select temp_table3;
+------+----------------------+----------------------+----------------------+
| No. | Row | Column | Cell |
+------+----------------------+----------------------+----------------------+
| 1 | Disney | length: | 124 |
+------+----------------------+----------------------+----------------------+
| 2 | Disney | studioName: | Disney |
+------+----------------------+----------------------+----------------------+
| 3 | Disney | year: | 1991 |
+------+----------------------+----------------------+----------------------+
| 4 | Fox | length: | 124 |
+------+----------------------+----------------------+----------------------+
| 5 | Fox | studioName: | Fox |
+------+----------------------+----------------------+----------------------+
| 6 | Fox | year: | 1977 |
+------+----------------------+----------------------+----------------------+
{code}
but, I should make logical operators(AND, OR, NOT) in selection command syntax.
> [HbaseShell] Relational Algrebra Operators
> ------------------------------------------
>
> Key: HADOOP-1608
> URL: https://issues.apache.org/jira/browse/HADOOP-1608
> Project: Hadoop
> Issue Type: Improvement
> Components: contrib/hbase
> Affects Versions: 0.13.0
> Environment: All environments
> Reporter: edward yoon
> Priority: Minor
> Attachments: shell_r_operators_v01.patch, shell_v02.patch
>
>
> Development of relational algebra operators has begun.
> * Projection
> * Selection
> * 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.
