create table using CTAS and add data to it

[Rishabh Bhardwaj]

Hi all,
I am new to Hive and was going through the tutorial and found this,
CREATE TABLE new_key_value_storeROW FORMAT SERDE 
"org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe"STORED AS RCFile AS
SELECT (key %1024) new_key, concat(key, value) key_value_pair FROM 
key_value_store SORT BY new_key, key_value_pair;

I am creating a table in a similar manner and my problem is ,
Suppose key_value_store table is partitioned by date and a new partition is 
added to it daily.Now I want to update the new_key_value_storeROW table with 
this data.
How should I do this ?

Thanks,
Rishabh.