hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: Crate Non-partitioned table from partitioned table using CREATE TABLE .. LIKE
Date Sun, 07 Aug 2016 13:25:15 GMT
Hi Marcin,

The thread owner  question was

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

This can be easily achieved through Spark by reading the Hive external
table (assuming that the thread owner knows its name and the Hive database
name :)) into a DF

DF will display all the column names and a filter on it can get rid of the
partition columns.

New table can be created without those two columns and of course will not
be partitioned.

 HTH

Dr Mich Talebzadeh



LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*



http://talebzadehmich.wordpress.com


*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.



On 7 August 2016 at 13:17, Marcin Tustin <mtustin@handybook.com> wrote:

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

Mime
View raw message