hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nagabhushanam Bheemisetty <nbheemise...@gmail.com>
Subject Re: Crate Non-partitioned table from partitioned table using CREATE TABLE .. LIKE
Date Thu, 04 Aug 2016 21:56:39 GMT
I only get the table names that I need to ingest. So I don't know the
master table schema upfront.

Yes the new table based on master table which is partitioned but new table
should not be partitioned and should not have partition column.

On Thu, Aug 4, 2016 at 4:54 PM Mich Talebzadeh <mich.talebzadeh@gmail.com>
wrote:

> Do you know the existing table schema? The new table schema will be based
> on that table without partitioning?
>
>
>
> 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 4 August 2016 at 22:05, 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.
>>
>
>

Mime
View raw message