select all dynamic columns by primary key if columns names are unknown

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

Re: select all dynamic columns by primary key if columns names are unknown

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

Re: select all dynamic columns by primary key if columns names are unknown

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

Re: select all dynamic columns by primary key if columns names are unknown

It super overhead, you have to query twice... 2016-02-02 22:34 GMT+01:00 Steve Terrell : > 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

Re: select all dynamic columns by primary key if columns names are unknown

It's not my usecase unfortunately... I have to log links between identities. Link presented as: id1, source1, id2, source2 means id1 came from source1 and id2 came from source2 and these ids are linked (a kind cross-site auth) the problem is that I set (id1, source1) as composite primary key and

Re: select all dynamic columns by primary key if columns names are unknown

Regarding the use of views to make dynamic fields appear as static fields, I have been unable to get them to work with dynamic fields. I am using Phoenix 3.2.2. 0: jdbc:phoenix:localhost> create view TMP_DYNA as select * from COLLECTIONS("category_hierarchy" varchar); REDError: ERROR 602