How to create phoenix table using existing hbase table ??

[#1]

my use case i need to create phoenix table by using existing hbase table. I have got only one way to map hbase table i,e creating view table. is there any other way to create phoenix table by using existing hbase table ??

[#2]

You may refer below section. https://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table

[#3 · Accepted solution]

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.

[#4]

CREATE TABLE table2 LIKE table1;

INSERT INTO table2 SELECT * FROM table1;

These are sql queries which can be used but not working with base..

By d way nice question.

I am also trying for it.