In my previous tables in Hbase, each column family has many qualifier: values pairs. When I try to create a view in Phoenix, no values shown in these columns. How to create a view to map all schema in my exsiting tables?
Lets say you have an existing HBase table called "transactions", column family called "transactions" that has a column called transactionId. You can map that table to a Phoenix view with: CREATE VIEW "TransactionHistory" (k VARCHAR primary key, "Transactions"."transactionId" VARCHAR);. Now you should be able to Select "transactionId" from "Transactions". You can use ALTER VIEW to add additional columns from he HBASE table after that.