CODEWITHSUNDEEP
clouderaimpala
Rolando
Rolando

Reputation: 62704

How to duplicate cloudera impala table with impala-shell or other means?

I see a table "test" in Impala when I do show tables;

I want to make a copy of the "test" table so that it is an exact duplicate, but named "test_copy". Is there a impala query I can execute to do this? If not, how can I do this?

Upvotes: 7

Views: 11246

Answers (2)

Shahab Tajik
Shahab Tajik

Reputation: 91

You can do this by a single command: CREATE TABLE new_table AS (SELECT * FROM table);

Upvotes: 9

Matt
Matt

Reputation: 4334

You can use the "CREATE TABLE test_copy LIKE test" to create a table with the same metadata. Then you can use "INSERT INTO TABLE test_copy SELECT * FROM test" to copy the data.

Upvotes: 14

Related Questions