phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Tianying Chang <tych...@gmail.com>
Subject Re: How to enable a HBase table to be phoenix-able
Date Sat, 22 Mar 2014 00:13:40 GMT
That works. Thanks

Tian-Ying


On Fri, Mar 21, 2014 at 5:01 PM, James Taylor <jamestaylor@apache.org>wrote:

> Hi Tianying,
> Try with our new 3.0 release candidate (
> http://mail-archives.apache.org/mod_mbox/incubator-phoenix-dev/201403.mbox/%3CCAAF1JdiBkqtR9FkEow-kGd1xsxZ%2B0B1-7NejH%3Duygocx_iM30g%40mail.gmail.com%3E).
>
>
> Follow the examples here: http://phoenix.incubator.apache.org/views.html
>
> Please note that Phoenix upper cases table, column, and column family
> names. So if your HBase table metadata isn't all uppercase, you need to put
> these names in double quotes as the FAQ outlines.
>
> Thanks,
> James
>
>
> On Fri, Mar 21, 2014 at 4:54 PM, Tianying Chang <tychang@gmail.com> wrote:
>
>> Hi, Mujtaba
>>
>> Thanks for the quick response.
>>
>> I tried that, but got error below
>>
>>  CREATE VIEW TestTable ( pk VARCHAR PRIMARY KEY, info.val VARCHAR );
>>
>> Error: ERROR 505 (42000): Table is read only. (state=42000,code=0)
>>
>>
>> On Fri, Mar 21, 2014 at 4:19 PM, Mujtaba Chohan <mujtaba@apache.org>wrote:
>>
>>> Hi Tian,
>>>
>>> Following page describes how you can use existing tables with Phoenix
>>> http://phoenix.incubator.apache.org/faq.html#How_I_create_Views_in_Phoenix_Whats_the_difference_between_ViewsTables
>>>
>>> //mujtaba
>>>
>>>
>>>
>>> On Fri, Mar 21, 2014 at 4:07 PM, Tianying Chang <tychang@gmail.com>wrote:
>>>
>>>> Hi,
>>>>
>>>> I have put the phoenix jar under the hbase/lib. and tested that I can
>>>> create a new table with sqlline, and do the select * statement.
>>>>
>>>> My question is how can I convert the existing HBase table  to run those
>>>> select commands? I have a HBase table that already has large amount of data
>>>> in it.
>>>>
>>>> Thanks
>>>> Tian-Ying
>>>>
>>>
>>>
>>
>

Mime
View raw message