question Re: How to create phoenix table using existing hbase table ?? in Archives of Support Questions (Read Only)

How to create phoenix table using existing hbase table ??

subhash_parise3 — Tue, 08 Mar 2016 18:45:57 GMT

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 ??

Re: How to create phoenix table using existing hbase table ??

asinghal — Tue, 08 Mar 2016 18:45:58 GMT

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

Re: How to create phoenix table using existing hbase table ??

vvaks — Mon, 28 Mar 2016 06:09:31 GMT

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.

Re: How to create phoenix table using existing hbase table ??

vishalb_engg — Thu, 22 Jun 2017 11:03:35 GMT

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.