hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zheng Shao <zsh...@gmail.com>
Subject Re: Deleted input files after load
Date Fri, 22 Jan 2010 19:05:45 GMT
If you want the files to stay there, you can try "CREATE EXTERNAL
TABLE" with a location (instead of create table + load)

Zheng

On Fri, Jan 22, 2010 at 10:51 AM, Bill Graham <billgraham@gmail.com> wrote:
> 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 <shivamy@gmail.com> 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
>
>



-- 
Yours,
Zheng

Mime
View raw message