Querying pre existing HBase table

["Bradman, Dale" <da...@capgemini.com>]

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.

Re: Querying pre existing HBase table

[Billy Watson <wi...@gmail.com>]

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 <an...@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 <da...@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
>

Re: Querying pre existing HBase table

[anil gupta <an...@gmail.com>]

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 <da...@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

Re: Querying pre existing HBase table

[James Taylor <ja...@apache.org>]

No, that's not possible. Phoenix needs to know the type information
and that's what the table/view definition is telling it.

Thanks,
James

On Tue, Apr 7, 2015 at 4:00 AM, Bradman, Dale
<da...@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.