Mailing-List: contact hadoop-dev-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: hadoop-dev@lucene.apache.org
Message-ID: <14719811.1193215131326.JavaMail.jira@brutus>
Date: Wed, 24 Oct 2007 01:38:51 -0700 (PDT)
From: "Edward Yoon (JIRA)" <jira@apache.org>
To: hadoop-dev@lucene.apache.org
Subject: [jira] Updated: (HADOOP-1608) [Hbase Shell] 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: quoted-printable


     [ https://issues.apache.org/jira/browse/HADOOP-1608?page=3Dcom.atlassi=
an.jira.plugin.system.issuetabpanels:all-tabpanel ]

Edward Yoon updated HADOOP-1608:
--------------------------------

    Affects Version/s:     (was: 0.14.3)
                       0.14.1
               Status: Open  (was: Patch Available)

> [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
>    Affects Versions: 0.14.1
>         Environment: All environments=20
>            Reporter: Edward Yoon
>            Priority: Minor
>             Fix For: 0.16.0
>
>         Attachments: patch_v01.txt, patch_v02.txt, patch_v03.txt, patch_v=
04.txt, patch_v05.txt, patch_v06.txt, patch_v07.txt, patch_v08.txt, patch_v=
09.txt, patch_v10.txt, patch_v11.txt, patch_v12.txt, patch_v13.txt
>
>
> Development of relational algebra operators has begun.
>  * Projection=20
>   ** selects a subset of the columnfamilies of a relation =20
>   ** Result =3D =CF=80 ~column_list~ (Relation)=20
> {code}
> Hbase > Result =3D Relation.Projection('year','legnth');
> Hbase > save Result into table('result');
> {code}
>  * Selection
>   ** See : HADOOP-2003 issue's description
> {code}
> Hbase > Result =3D Relation.Selection(length > 100 and studioName =3D 'Fo=
x');=20
> Hbase > save Result into table('result');
> {code}
>  * Group
>   ** more details about 'GROUP' operation will be handled in HADOOP-1658 =
issue.=20
>  * =CE=B8 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=3Dn+m and attributes (A ~1~,A ~2~,=
...,A ~n~, B ~1~,B ~2~,...,B ~m~) that satisfy the join condition
> {code}
> Hbase > R1 =3D table('movieLog_table');
> Hbase > R2 =3D table('personInfo_table');
> Hbase > Result =3D R1.join(R1.producer: =3D R2.ROW) and R2;=20
>      or Result =3D R1.join(R1.actor:hero =3D R2.Row) and R2;
>      or Result =3D R1.join(R1.actor:hero =3D R2.Row and R1.studioName =3D=
 'Fox' and R2.occupation =3D 'singer');
> {code}

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.