phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject Re: View composite key?
Date Wed, 24 Sep 2014 15:57:53 GMT
Oh nice! Thanks for this example!

JM

2014-09-24 11:50 GMT-04:00 James Taylor <jamestaylor@apache.org>:

> Hi JM,
> Sure, you'd do that like this:
>
> CREATE VIEW "t1" ( USER unsigned_long,
> ID unsigned_long,
> VERSION unsigned_long,
>    "f1".A unsigned_long,
>    "f1".R unsigned_long,
>    "f1".L unsigned_long,
>    "f1".W unsigned_long,
>    "f1".P bigint,
>    "f1".N varchar,
>    "f1".E varchar,
>    "f1".S unsigned_long,
>    "f1".M unsigned_long,
>    "f1".T unsigned_int,
>    CONSTRAINT pk PRIMARY KEY (USER, ID, VERSION)
>    );
>
> Thanks,
> James
>
> On Wed, Sep 24, 2014 at 6:21 AM, Jean-Marc Spaggiari
> <jean-marc@spaggiari.org> wrote:
> > Hi,
> >
> > Is it possible to create a view on and existing HBase table and describe
> the
> > composite key?
> >
> > I don't see anything about that in the doc
> > http://phoenix.apache.org/views.html but it also doesn't say that it's
> not
> > possible.
> >
> > Would like to do something like that:
> > CREATE VIEW "t1" ( USER unsigned_long PRIMARY KEY,
> > ID unsigned_long PRIMARY KEY,
> > VERSION unsigned_long PRIMARY KEY,
> >    "f1".A unsigned_long,
> >    "f1".R unsigned_long,
> >    "f1".L unsigned_long,
> >    "f1".W unsigned_long,
> >    "f1".P bigint,
> >    "f1".N varchar,
> >    "f1".E varchar,
> >    "f1".S unsigned_long,
> >    "f1".M unsigned_long,
> >    "f1".T unsigned_int
> >    );
> >
> > Where USER, ID and VERSIONS are 8 bytes longs from my HBase rowkey.
> >
> > Is that doable?
> >
> > Thanks,
> >
> > JM
>

Mime
View raw message