Hi Mark, You can use 'External table' in Hive. http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL
<http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL>Hive external table does not move or delete files. - Youngwoo 2010/12/15 Mark <static.void....@gmail.com> > When I load a file from HDFS into hive i notice that the original file has > been removed. Is there anyway to prevent this? If not, how can I got back > and dump it as a file again? Thanks >