Just to not steer you in the wrong direction, you do have to create a table, but you do not have to tell phoenix every column you're going to query on as of Phoenix 1.2.
http://phoenix.apache.org/dynamic_columns.html So yes, phoenix needs to know the types, but it doesn't have to know them up front, FWIW. I'm not sure of your exact use case, obviously. William Watson Software Engineer (904) 705-7056 PCS On Tue, Apr 7, 2015 at 12:57 PM, anil gupta <anilgupt...@gmail.com> wrote: > No, You need to at least define a view for that table. Phoenix wouldnt > know how to read columns/rowkeys of your table. > > On Tue, Apr 7, 2015 at 4:00 AM, Bradman, Dale <dale.brad...@capgemini.com> > wrote: > >> Hello, >> >> Is it possible to issue a SELECT statement on a pre existing HBase >> table without having to create a Phoenix table/view on top of the HBase >> table? >> >> Thanks, Dale. >> This message contains information that may be privileged or confidential >> and is the property of the Capgemini Group. It is intended only for the >> person to whom it is addressed. If you are not the intended recipient, you >> are not authorized to read, print, retain, copy, disseminate, distribute, >> or use this message or any part thereof. If you receive this message in >> error, please notify the sender immediately and delete all copies of this >> message. >> > > > > -- > Thanks & Regards, > Anil Gupta >