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
>>
>
>
|