Hi,

http://wiki.apache.org/hadoop/Hive/LanguageManual/DML

>From the wiki above.... " Currently the OVERWRITE keyword is mandatory and 
>implies that the contents of the chosen table or partition are replaced with 
>the output of corresponding select statement."

How would one insert (more data) into an existing table(with some data already 
in it).

If I am reading the correct documentation, then how do people workaround this 
restriction. I am sure this is common enough use-case.

I am trying to do
INSERT INTO TABLE t1 partition(p1='x', p2='y') select a, b from t2;

and I need to do this repeatedly when more data arrives into t2(or some other 
table);


Thanks
Vinay



      

Reply via email to