phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: View composite key?
Date Wed, 24 Sep 2014 15:50:37 GMT
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