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
