Re: How to upsert data into dynamic columns in phoniex.

2015-06-23 Thread Thomas D'Silva
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

Re: How to upsert data into dynamic columns in phoniex.

2015-06-22 Thread Thomas D'Silva
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,

How to upsert data into dynamic columns in phoniex.

2015-06-21 Thread guxiaobo1982
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