I encourage you to use views[1] instead. You can dynamically add/remove columns from a view and this way Phoenix keeps track of it for you and you get all the other standard features. Thanks, James
[1] https://phoenix.apache.org/views.html On Tue, Feb 2, 2016 at 1:42 PM, Serega Sheypak <[email protected]> wrote: > It super overhead, you have to query twice... > > 2016-02-02 22:34 GMT+01:00 Steve Terrell <[email protected]>: > >> I would like to know as well. Today when I upsert and create dynamic >> columns, I have to also create a second table to keep track of the dynamic >> field names and data types that were upserted so that the person writing >> queries for the first table can know what's fields are available. >> >> Also would like to know if there is a way to do bulk upserting with >> dynamic fields. >> >> On Tue, Feb 2, 2016 at 3:27 PM, Serega Sheypak <[email protected]> >> wrote: >> >>> Hi, is it possible to select all dynamic columns if you don't know their >>> names in advance? >>> Example: >>> >>> I have a table with single defined column named PK, which is a primary >>> key >>> >>> Someone runs query: >>> >>> UNSERT INTO MY_TBL(PK, C1, C2, C3) VALUES('x', '1', '2', '3') >>> >>> where C1, C2, C3 are dynamic columns >>> >>> then I want to select all columns using query: >>> select * from MY_TBL where PK = 'x' >>> But this query won't return C1, C2, C3 columns. >>> >>> >> >
