It's not about data. Would like to clone just the table structure(s) under the schema partially or entire tables.
Kumar Palaniappan > On Sep 8, 2016, at 5:48 PM, dalin.qin <[email protected]> wrote: > > 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. >
