hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcin Tustin <mtus...@handybook.com>
Subject Re: Crate Non-partitioned table from partitioned table using CREATE TABLE .. LIKE
Date Sun, 07 Aug 2016 13:19:11 GMT
Why exclude the partition column? It will still be unpartitioned whether or
not the partition column is excluded.

On Sun, Aug 7, 2016 at 8:23 AM, Markovitz, Dudu <dmarkovitz@paypal.com>
wrote:

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

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


Mime
View raw message