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 Thu, 04 Aug 2016 22:06:15 GMT
Which process creates the master table in Hive as an external table? There
must be a process that creates the master table as external table?  Hive
knows about the schema of that table. It is in Hive metastore.

You cannot create an external table with CREATE EXTERNAL TABLE AS ...

hive> CREATE EXTERNAL TABLE sales5 AS SELECT * FROM SALES;
FAILED: SemanticException [Error 10070]: CREATE-TABLE-AS-SELECT cannot
create external table

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:56, Nagabhushanam Bheemisetty <nbheemisetty@gmail.com
> wrote:

> 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