Hi Bhavesh This is the expected behavior from hive, If you want to overwrite the data in table on new data loads use OVERWRITE. LOAD DATA without OVERWRITE is used to just append new data to existing data in a hive table.
load data local inpath '/home/hadoop/quarter.txt' OVERWRITE into table quartertable Then about quarter.txt_copy_1 quarter.txt_copy_2 quarter.txt_copy_3 quarter.txt_copy_4 Since the target hdfs dir already has a quarter.txt, the next files are renamed during hdfs copy. Hope it helps!... Regards Bejoy.K.S ________________________________ From: Bhavesh Shah <bhavesh25s...@gmail.com> To: user@hive.apache.org Sent: Tuesday, January 17, 2012 10:54 AM Subject: Problem related to Hive - LOAD DATA Hello, I am using hive LOAD DATA command. I am writing some content in one text file and loading that content into table every time when I write that file. But when I use LOAD DATA command: "load data local inpath '/home/hadoop/quarter.txt' into table quartertable" In HDFS, for the first time I saw file quarter.txt after loading, but later when I tried for multiple times, in HDFS, I saw loaded files as: quarter.txt quarter.txt_copy_1 quarter.txt_copy_2 quarter.txt_copy_3 quarter.txt_copy_4 And when I access this quartertable I get the data from all this files. What should I do to maintain just one file and to keep overwrite it? Pls suggest me. Thanks. -- Regards, Bhavesh Shah
