Return-Path: Delivered-To: apmail-hadoop-pig-user-archive@www.apache.org Received: (qmail 622 invoked from network); 7 Jan 2009 19:53:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 7 Jan 2009 19:53:02 -0000 Received: (qmail 19149 invoked by uid 500); 7 Jan 2009 19:53:01 -0000 Delivered-To: apmail-hadoop-pig-user-archive@hadoop.apache.org Received: (qmail 19117 invoked by uid 500); 7 Jan 2009 19:53:01 -0000 Mailing-List: contact pig-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: pig-user@hadoop.apache.org Delivered-To: mailing list pig-user@hadoop.apache.org Received: (qmail 19106 invoked by uid 99); 7 Jan 2009 19:53:01 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jan 2009 11:53:01 -0800 X-ASF-Spam-Status: No, hits=3.4 required=10.0 tests=HTML_MESSAGE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [74.125.92.26] (HELO qw-out-2122.google.com) (74.125.92.26) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Jan 2009 19:52:53 +0000 Received: by qw-out-2122.google.com with SMTP id 3so4066287qwe.35 for ; Wed, 07 Jan 2009 11:52:31 -0800 (PST) Received: by 10.214.79.3 with SMTP id c3mr20230577qab.370.1231357951712; Wed, 07 Jan 2009 11:52:31 -0800 (PST) Received: by 10.215.12.1 with HTTP; Wed, 7 Jan 2009 11:52:31 -0800 (PST) Message-ID: Date: Wed, 7 Jan 2009 11:52:31 -0800 From: "Jeff Hammerbacher" To: pig-user@hadoop.apache.org Subject: Re: Pigi and "Entity Attribute Value" model In-Reply-To: <7c67660901070218t5abafe04rfc93c66d731c29cf@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_89622_30036922.1231357951667" References: <7c67660901070218t5abafe04rfc93c66d731c29cf@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_89622_30036922.1231357951667 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hey Yonatan, This mailing list is for the Apache Pig project; you can subscribe to the Pigi project mailing list by sending a message to pigi-subscribe@list.pigi-project.org. I'm sure they'll be able to help over there. Regards, Jeff On Wed, Jan 7, 2009 at 2:18 AM, yonatan maman wrote: > Hi all > Entity Attribute Value > model(aka > EAV model) is a simple relational model. in my use case I have a > schema > which looks like this: > > Table EAV: > > col1: entityID > col2: attributeName > col3: value > > > and I want to use Pig and HBASe. > query requirements: > > I want to be able to query on ALL 3 columns. for example : > > * for a given an entityID I want to get all its attributes and values > * for a give attributeName and value I want to all the entityIDs ... > > Will Pig can help me doing that ? > > -- Yonatan > ------=_Part_89622_30036922.1231357951667--