hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amlan Mandal <am...@fourint.com>
Subject Loading files into tables
Date Tue, 01 Feb 2011 11:15:02 GMT
Hi All,
I am a hive newbie.

LOAD DATA *LOCAL* INPATH 'filepath' [OVERWRITE] INTO TABLE tablename

When I use LOCAL keyword does hive create a hdfs file for it?

I used above statement to put data into a hive table.
But I could not see any hdfs file in my hive.metastore.warehouse.dir (which
comes from hive-default.xml /user/hive/warehouse/ ).

Although when I did

FROM  a INSERT OVERWRITE TABLE
b PARTITION(dt='2011-01-06') SELECT *

I see hdfs file is created.

Am I missing something?

Can somebody please explain?

Mime
View raw message