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 <[email protected]> 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
