phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <>
Subject View composite key?
Date Wed, 24 Sep 2014 13:21:59 GMT

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 but it also doesn't say that it's not

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?



View raw message