create a view on existing production table ?

2015-06-24 Thread Sergey Malov
My apologies if this info can be found somewhere, I don’t see it. I have a production table “profile” with the following schema : {NAME => 'edge', BLOOMFILTER => 'ROW', VERSIONS => '2', IN_MEMORY => 'false', KEEP_DELETED_CELLS => 'false', DATA_BLOCK_ENCODING => 'FAST_DIFF', COMPRESSION => 'SNAP

Re: create a view on existing production table ?

2015-06-26 Thread James Taylor
Hi Sergey, Yes, you can create a Phoenix view over this HBase table, but you have to explicitly list columns by name (i.e. column qualifier) either at view creation time or at read time (using dynamic columns). Also, the row key must conform to what Phoenix expects if there are multiple columns in

Re: create a view on existing production table ?

2015-06-26 Thread Sergey Malov
t;> Date: Friday, June 26, 2015 at 12:04 To: "user@phoenix.apache.org<mailto:user@phoenix.apache.org>" mailto:user@phoenix.apache.org>> Subject: Re: create a view on existing production table ? Hi Sergey, Yes, you can create a Phoenix view over this HBase table, but yo

Re: create a view on existing production table ?

2015-06-26 Thread James Taylor
From: James Taylor > > Reply-To: "user@phoenix.apache.org > " < > user@phoenix.apache.org > > > Date: Friday, June 26, 2015 at 12:04 > To: "user@phoenix.apache.org > " < > user@phoenix.apache.org > > > Subject: Re: create a view on exist

Re: create a view on existing production table ?

2015-06-26 Thread anil gupta
? >> >> Thank you, >> Sergey >> >> From: James Taylor >> Reply-To: "user@phoenix.apache.org" >> Date: Friday, June 26, 2015 at 12:04 >> To: "user@phoenix.apache.org" >> Subject: Re: create a view on existing production

Re: create a view on existing production table ?

2015-07-06 Thread Sergey Malov
y-To: "user@phoenix.apache.org<mailto:user@phoenix.apache.org>" mailto:user@phoenix.apache.org>> Date: Friday, June 26, 2015 at 18:28 To: "user@phoenix.apache.org<mailto:user@phoenix.apache.org>" mailto:user@phoenix.apache.org>> Subject: Re: create a view on

Re: create a view on existing production table ?

2015-07-06 Thread anil gupta
ate a view using dynamic columns that I can query later ? > > Thank you, > Sergey Malov > > From: anil gupta > Reply-To: "user@phoenix.apache.org" > Date: Friday, June 26, 2015 at 18:28 > > To: "user@phoenix.apache.org" > Subject: Re: create

Re: create a view on existing production table ?

2015-07-07 Thread Sergey Malov
t;> Date: Tuesday, July 7, 2015 at 02:49 To: "user@phoenix.apache.org<mailto:user@phoenix.apache.org>" mailto:user@phoenix.apache.org>> Subject: Re: create a view on existing production table ? Hi Sergey, You **can't** create a view that would work with dynamic colum

Re: create a view on existing production table ?

2015-07-07 Thread Anil Gupta
n, > sacrifices should be made. > > Thank you, > Sergey Malov > > From: anil gupta > Reply-To: "user@phoenix.apache.org" > Date: Tuesday, July 7, 2015 at 02:49 > To: "user@phoenix.apache.org" > Subject: Re: create a view on existing production t