hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vidya Sujeet <sjayatheer...@gmail.com>
Subject Re: Errors while creating a new table using existing table schema
Date Sat, 19 Jul 2014 07:23:45 GMT
>
> Hello,
>
> I am trying to create a new table using an existing table's schema
> (existing table name in hive: jobs). However, when I do that it doesn't put
> the new table (new table name in hive: jobs_ex2) in the same location as
> the existing table. When I specify the location explicitly, it errors out.
>
>
> Query which has the problem is pasted below:
>
>
>
>
>
> *create table jobs_ex2as select year, capitalregion, universe from jobsrow
> format delimited fields terminated by
> ','                                           Location
> '/user/hive/warehouse/default.db/jobs_ex2'*
>
> The file that is being used to create a table is in the following
> location:  */user/hive/warehouse/default.db/jobs/universe=1/Jobs.csv*
> where universe=1 is the partition. The new table jobs_ex_2 needs to be
> created inside default.db folder.
>
> thanks,
> Vidya
>

Mime
View raw message