hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Markovitz, Dudu" <dmarkov...@paypal.com>
Subject RE: Crate Non-partitioned table from partitioned table using CREATE TABLE .. LIKE
Date Sun, 07 Aug 2016 12:23:05 GMT
It won’t help him since ‘*’ represent all columns including the partition columns which
he wants to exclude.

Dudu

From: Marcin Tustin [mailto:mtustin@handybook.com]
Sent: Sunday, August 07, 2016 3:17 PM
To: user@hive.apache.org
Subject: Re: Crate Non-partitioned table from partitioned table using CREATE TABLE .. LIKE

Will CREATE TABLE sales5 AS SELECT * FROM SALES; not work for you?

On Thu, Aug 4, 2016 at 5:05 PM, Nagabhushanam Bheemisetty <nbheemisetty@gmail.com<mailto:nbheemisetty@gmail.com>>
wrote:
Hi I've a scenario where I need to create a table from partitioned table but my destination
table should not be partitioned. I won't be knowing the schema so I cannot create manually
the destination table. By the way both tables are external tables.


Want to work at Handy? Check out our culture deck and open roles<http://www.handy.com/careers>
Latest news<http://www.handy.com/press> at Handy
Handy just raised $50m<http://venturebeat.com/2015/11/02/on-demand-home-service-handy-raises-50m-in-round-led-by-fidelity/>
led by Fidelity

[http://marketing-email-assets.handybook.com/smalllogo.png]
Mime
View raw message