Mailing-List: contact hadoop-dev-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hadoop-dev@lucene.apache.org
Message-ID: <10781834.1185354991320.JavaMail.jira@brutus>
Date: Wed, 25 Jul 2007 02:16:31 -0700 (PDT)
From: "edward yoon (JIRA)" <jira@apache.org>
To: hadoop-dev@lucene.apache.org
Subject: [jira] Updated: (HADOOP-1608) [HbaseShell] Relational Algrebra
 Operators
In-Reply-To: <30939913.1184326504508.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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