hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "edward yoon (JIRA)" <j...@apache.org>
Subject [jira] Updated: (HADOOP-1608) [HbaseShell] Relational Algrebra Operators
Date Wed, 25 Jul 2007 09:16:31 GMT

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


Mime
View raw message