hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Raunak Jhawar <raunak.jha...@gmail.com>
Subject Re: External Table without Location
Date Fri, 27 Mar 2015 14:10:41 GMT
This is not a bug. If you do not explicitly specify location for a table,
it will use the default database.

--
Thanks,
Raunak Jhawar
m: 09820890034






On Fri, Mar 27, 2015 at 5:04 PM, Parth Anand <Parth.Anand@pb.com> wrote:

>  Hi,
>
>  I was trying to create External table in hive.
>
>
> I used "create external table ext_2 (id string,name string) row format
> delimited fields terminated by ',' stored as textfile" command.
>
>
>
> This command created a table with external property as I checked by using
> "describe formatted ext_1" command.
>
>
>
> But when I used "Load data inpath 'file_path' into table ext_1" command to
> load data in table, *File in that path is transferred to hive directory*.
>
>
>
> According to documentation of external table at the time of creation
> external table we have to mention location of its file.
> and that file is not relocated to hive directory but in this case it is
> not behaving same. I am able to create external table without  giving file
> path at the time of creation and that file is also getting transferred to
> Hive Directory.
>
>
>
> Can you please explain the usage of external table?? Is this is a bug?
>
>
>
>
>
> Regards
>
> Parth Anand
>
>
>
> ------------------------------
>
>

Mime
View raw message