try this: 0: jdbc:phoenix:namenode:2181:/hbase-unsecure> CREATE TABLE TABLE1 (ID BIGINT NOT NULL PRIMARY KEY, COL1 VARCHAR); No rows affected (1.287 seconds) 0: jdbc:phoenix:namenode:2181:/hbase-unsecure> UPSERT INTO TABLE1 (ID, COL1) VALUES (1, 'test_row_1'); 1 row affected (0.105 seconds) 0: jdbc:phoenix:namenode:2181:/hbase-unsecure> UPSERT INTO TABLE1 (ID, COL1) VALUES (2, 'test_row_2'); 1 row affected (0.011 seconds) 0: jdbc:phoenix:namenode:2181:/hbase-unsecure> CREATE TABLE TABLE2 (ID BIGINT NOT NULL PRIMARY KEY, COL1 VARCHAR); No rows affected (1.251 seconds) 0: jdbc:phoenix:namenode:2181:/hbase-unsecure> upsert into table2 select * from table1; 2 rows affected (0.049 seconds) 0: jdbc:phoenix:namenode:2181:/hbase-unsecure> select * from table2; +-----+-------------+ | ID | COL1 | +-----+-------------+ | 1 | test_row_1 | | 2 | test_row_2 | +-----+-------------+ 2 rows selected (0.06 seconds)
On Thu, Sep 8, 2016 at 4:17 PM, Kumar Palaniappan < [email protected]> wrote: > What is an easy solution or is there a solution to clone the table/schema > in phoenix? > > Thanks in advance. > > >
