https://community.cloudera.com/t5/Support-Questions/Hive-overwrites-existing-external-table-data/m-p/231858#M193701 <P>Hello guys,</P><P> I am trying to execute multiple insert queries into a table which looks like the next one:</P> <PRE>create external table test1(c1 int, c2 int) CLUSTERED BY(c1) SORTED BY(c1) INTO 4 BUCKETS ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE LOCATION '/user/companies/'; </PRE><P>Although I noticed that Hive is overriding the existing data on each insert(). I am running Hive v.1.2.1000 with HDP-2.6.3.0</P><P>I already found <A href="https://community.hortonworks.com/questions/97008/hive-insert-into-s3-external-table-overwrites-whol.html">this</A> similar issue and I was wondering if someone has any suggestions or solution for this one</P><P>Thank you</P> Fri, 29 Dec 2017 06:01:43 GMT abiratsis 2017-12-29T06:01:43Z