I have created a table with few CF and initial list of qualifiers. Later on while UPSERTing data into the table with dynamic qualifiers, it was successfully added. But I am not able to view them anymore.
CREATE TABLE IF NOT EXISTS EMPDETAIL (id bigint not null, name varchar(255) not null, age bigint, address.addr1 varchar(1000), address.addr2 varchar(1000), address.addr3 varchar(1000),
CONSTRAINT EMPDETAIL_PK PRIMARY KEY (id,name))
"select * from myTable" in Phoenix will only return columns defined in the table DDL. To include dynamic columns in query results, you must explicitly include them in the select clause. See the docs for an example.
This is where views come in handy. Instead of manually defining dynamic columns in each query, you can define them once in a view, then select * from myView.