pig-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jeff Hammerbacher" <ham...@cloudera.com>
Subject Re: Pigi and "Entity Attribute Value" model
Date Wed, 07 Jan 2009 19:52:31 GMT
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 <yonatanm@gmail.com> wrote:

> Hi all
>  Entity Attribute Value
> model<http://en.wikipedia.org/wiki/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
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message