hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ajo Fod <ajo....@gmail.com>
Subject Re: Loading files into tables
Date Tue, 01 Feb 2011 13:21:02 GMT
Look up for local :
http://wiki.apache.org/hadoop/Hive/GettingStarted

-Ajo.

On Tue, Feb 1, 2011 at 3:15 AM, Amlan Mandal <amlan@fourint.com> wrote:

> 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