Hive doesn't delete the files upon load, it moves them to a location under the Hive warehouse directory. Try looking under /user/hive/warehouse/t_word_count.
On Fri, Jan 22, 2010 at 10:44 AM, Shiva <[email protected]> wrote: > Hi, > For the first time I used Hive to load couple of word count data input > files into tables with and without OVERWRITE. Both the times the input file > in HDFS got deleted. Is that a expected behavior? And couldn't find any > definitive answer on the Hive wiki. > > hive> LOAD DATA INPATH '/user/vmplanet/output/part-00000' OVERWRITE > INTO TABLE t_word_count; > > Env.: Using Hadoop 0.20.1 and latest Hive on Ubuntu 9.10 running in VMware. > > Thanks, > Shiva >
