Hi Thomas, I tried your suggestion, the result is
the upsert statement with new column defined works, but subsequent queries can't find the new column, which is select * from eventlog will not show the new defined column lastGCTime and select lastGCTime from eventlog fails with undefined column error. is there a bug? ------------------ Original ------------------ From: "Thomas D'Silva";<tdsi...@salesforce.com>; Send time: Tuesday, Jun 23, 2015 5:44 AM To: "user"<user@phoenix.apache.org>; Subject: Re: How to upsert data into dynamic columns in phoniex. You can upsert rows by sepecifying the column name and data type along with the table in the select. For the example in http://phoenix.apache.org/dynamic_columns.html UPSERT INTO TABLE (eventId, eventTime, lastGCTime INTEGER) VALUES(1, CURRENT_TIME(), 1234); On Sun, Jun 21, 2015 at 6:51 PM, guxiaobo1982 <guxiaobo1...@qq.com> wrote: > Hi, > > The official doc only gives an example for querying dynamic columns which > are not defined at table creating time, but how can create the dynamic > columns in the schema and get data upsert through the phoniex API? > > Thanks
