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