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 View composite key?
Date Wed, 24 Sep 2014 13:21:59 GMT
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