Hi, While loading data in hive from pig using HCatalog the data is getting appended instead of overwritten, however documentation states otherwise: "You can write to a non-partitioned table simply by using HCatStorer. The contents of the table will be overwritten:" <https://cwiki.apache.org/confluence/display/Hive/HCatalog+LoadStore#HCatalogLoadStore-HCatStorer> ... #create table test(numbr int,name string) row format delimited fields terminated by ','; ... # grunt> STORE A into 'test' USING org.apache.hive.hcatalog.pig.HCatStorer(); # grunt> STORE A into 'test' USING org.apache.hive.hcatalog.pig.HCatStorer(); ... # hive> select * from test;
Does someone know how to make it overwrite, or why it appends? Sincerely, Artur Sukhenko -- -- Artur Sukhenko
