Since lastGCTime is a dynamic column you need to specify the dynamic column explicitly along with the table name.
Select lastGCTime FROM EventLog(lastGCTime TIME) Select * will return only the regular columns (and not dynamic columns). On Tue, Jun 23, 2015 at 12:09 AM, guxiaobo1982 <[email protected]> wrote: > 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";<[email protected]>; > Send time: Tuesday, Jun 23, 2015 5:44 AM > To: "user"<[email protected]>; > 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 <[email protected]> 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
