[
https://issues.apache.org/jira/browse/HADOOP-1608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Edward Yoon updated HADOOP-1608:
--------------------------------
Description:
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}
* Group
** more details about 'GROUP' operation will be handled in HADOOP-1658 issue.
* θ Join
** The join of two relations R1(A ~1~,A ~2~,...,A ~n~) and
R2(B~1~,B~2~,...,B~m~) is a relation with degree k=n+m and attributes (A ~1~,A
~2~,...,A ~n~, B ~1~,B ~2~,...,B ~m~) that satisfy the join condition
{code}
Hbase > R1 = table('movieLog_table');
Hbase > R2 = table('personInfo_table');
Hbase > Result = R1.join(R1.producer = R2.ROW) and R2;
{code}
was:
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}
* Group
** more details about 'GROUP' operation will be handled in HADOOP-1658 issue.
* θ Join
description update.
> [Hbase Shell] 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, patch_v07.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}
> * Group
> ** more details about 'GROUP' operation will be handled in HADOOP-1658
> issue.
> * θ Join
> ** The join of two relations R1(A ~1~,A ~2~,...,A ~n~) and
> R2(B~1~,B~2~,...,B~m~) is a relation with degree k=n+m and attributes (A
> ~1~,A ~2~,...,A ~n~, B ~1~,B ~2~,...,B ~m~) that satisfy the join condition
> {code}
> Hbase > R1 = table('movieLog_table');
> Hbase > R2 = table('personInfo_table');
> Hbase > Result = R1.join(R1.producer = R2.ROW) and R2;
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
