View composite key?

2014-09-24 Thread Jean-Marc Spaggiari
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

Re: View composite key?

2014-09-24 Thread James Taylor
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

Re: View composite key?

2014-09-24 Thread Jean-Marc Spaggiari
Oh nice! Thanks for this example! JM 2014-09-24 11:50 GMT-04:00 James Taylor jamestay...@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,