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