How to unload data from hive's tables

[zhu weimin <xi...@tsm.kddilabs.jp>]

Hi

I know how to load data from local file system or hdfs into tables using
"LOAD DATA ...".
But I want to remove some data files from hive's tables.
How to do it?

Thanks for any help.

Re: How to unload data from hive's tables

[Zheng Shao <zs...@gmail.com>]

There is no command for that in Hive.
You can manually remove the files from
/user/hive/warehouse/<tablename> (or the directory in your
hive-site.xml if you changed the default)


On Mon, Apr 5, 2010 at 6:41 PM, zhu weimin <xi...@tsm.kddilabs.jp> wrote:
> Hi
>
> I know how to load data from local file system or hdfs into tables using
> "LOAD DATA ...".
> But I want to remove some data files from hive's tables.
> How to do it?
>
> Thanks for any help.
>
>
>



-- 
Yours,
Zheng