https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-View-in-Phoenix-to-connect-to-existing-tables/m-p/99464#M12673 <P>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.</P> Mon, 28 Mar 2016 06:14:01 GMT vvaks 2016-03-28T06:14:01Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-View-in-Phoenix-to-connect-to-existing-tables/m-p/99461#M12670 <P>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?</P> Wed, 16 Dec 2015 08:12:58 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-View-in-Phoenix-to-connect-to-existing-tables/m-p/99461#M12670 cui_lin 2015-12-16T08:12:58Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-View-in-Phoenix-to-connect-to-existing-tables/m-p/99462#M12671 <P>You have to explicitly list of column names in the CREATE TABLE statement, or you can use dynamic columns at the query time to specify the list of columns for this query.</P> Wed, 16 Dec 2015 08:17:22 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-View-in-Phoenix-to-connect-to-existing-tables/m-p/99462#M12671 Enis 2015-12-16T08:17:22Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-View-in-Phoenix-to-connect-to-existing-tables/m-p/99463#M12672 <P>As Enis said and for details you can look on below page:-</P><P><A href="https://phoenix.apache.org/faq.html" target="_blank">https://phoenix.apache.org/faq.html</A></P> Sat, 30 Jan 2016 15:26:16 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-View-in-Phoenix-to-connect-to-existing-tables/m-p/99463#M12672 asinghal 2016-01-30T15:26:16Z https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-View-in-Phoenix-to-connect-to-existing-tables/m-p/99464#M12673 <P>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.</P> Mon, 28 Mar 2016 06:14:01 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/How-to-create-View-in-Phoenix-to-connect-to-existing-tables/m-p/99464#M12673 vvaks 2016-03-28T06:14:01Z