CODEWITHSUNDEEP
hivehiveql
不好笑
不好笑

Reputation: 105

Hive - Create new Table and insert updated data into it

is Hive allow us to select updated data and create new table? Which means a new table will be created using the same schema of old table after some row of data is updated.

Upvotes: 0

Views: 272

Answers (1)

David דודו Markovitz
David דודו Markovitz

Reputation: 44941

CTAS (Create Table As Select)

The basic syntax:

create table my_new_table
as
select  ... 
from    my_table
;

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTableAsSelect(CTAS)

Upvotes: 2

Related Questions