>
> 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
>
