Re: Errors while creating a new table using existing table schema

thanks all. I created a new database and it works fine there.. On Sat, Jul 19, 2014 at 1:37 PM, Lefty Leverenz wrote: > And now it's documented in the DDL wiki: > >- Use Database > > >

Re: Errors while creating a new table using existing table schema

And now it's documented in the DDL wiki: - Use Database - Create Table (notes aft

Re: Errors while creating a new table using existing table schema

André, thanks for the reminder about USE , which hadn't been documented in the wiki. I've added a note to the Select Syntax section (for starters). -- Lefty On Sat, Jul 19, 2014 at 4:52 AM

Re: Errors while creating a new table using existing table schema

Hi Vidya, I believe you need to remove Location '/user/hive/warehouse/default.db/jobs_ex2' line since it stores the table automatically in warehouse once you create the table. On Sat, Jul 19, 2014 at 1:46 AM, Andre Araujo wrote: > Vidya, > > I'm not sure I've understood your problem correctly.

Re: Errors while creating a new table using existing table schema

Vidya, I'm not sure I've understood your problem correctly. But if you want to create a table in the default database you can do either: use default; create table jobs_ex2 as select ... OR create table default.jobs_ex2 as select ... With that you don't need to specify the LOCATION clause. Howe

Re: Errors while creating a new table using existing table schema

> > 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 while creating a new table using existing table schema

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.