Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of dnquark@gmail.com designates
 209.85.161.54 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=NVAIN4RZavzu+hV3wz9S6wQ9/24y5bDVGP3L2OKNgdvmpYeirxyzko439DkXvYRaYo
         RhdAuWSZTg+4jvWdtWv38KEgqll2WnXH7OqnrsAILNYNKbFJbp0kaOGetHOQBssTCSuj
         xf76Ahw187EVjXiNfbzTUuWwTlSNy4fy9abgo=
MIME-Version: 1.0
In-Reply-To: <4D09504E.3080809@gmail.com>
References: <4D09504E.3080809@gmail.com>
Date: Wed, 15 Dec 2010 15:51:00 -0800
Message-ID: <AANLkTi=LSSJJkdW1nQj5q+JDneEEEUz+0TZ2G0kWUNev@mail.gmail.com>
Subject: Re: Tables and importing
From: Leo Alekseyev <dnquark@gmail.com>
To: user@hive.apache.org
Content-Type: text/plain; charset=ISO-8859-1

You can use CREATE EXTERNAL TABLE... LOCATION.

See http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL and examples
thereof.  When you LOAD DATA INPATH, the directory gets moved to the
Hive warehouse dir; it does not get modified.

On Wed, Dec 15, 2010 at 3:33 PM, Mark <static.void.dev@gmail.com> wrote:
> Can someone explain what actually happens when you create a table and import
> data into using "LOAD DATA INPATH..."
>
> I noticed that when I load the data from files already existing in HDFS that
> it actually removes the original file from its location and moves it under
> the /user/hive directory. Is there anyway I can prevent this from happening
> or is this just the way things work? At this point is the file modified in
> anyway? I have some other Hadoop jobs that rely on this data. Should I just
> update those jobs to operate on the data within these directories? Thanks
>