That works. Thanks Tian-Ying
On Fri, Mar 21, 2014 at 5:01 PM, James Taylor <[email protected]>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 <[email protected]> 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 <[email protected]>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 <[email protected]>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 >>>> >>> >>> >> >
