Yes you are correct that is just meta copy and I need only that but without partition:(
On Thu, Aug 4, 2016 at 5:15 PM Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > yes but that essentially copies the metadata and leaves the partition > there with no data. it is just an image copy. won't help this case > > 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 23:08, Nagabhushanam Bheemisetty < > nbheemise...@gmail.com> wrote: > >> Well you can create using like. >> >> >> CREATE EXTERNAL TABLE sales5 LIKE sales; >> >> >> On Thu, Aug 4, 2016 at 5:06 PM Mich Talebzadeh <mich.talebza...@gmail.com> >> wrote: >> >>> 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 < >>> nbheemise...@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.talebza...@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 < >>>>> nbheemise...@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. >>>>>> >>>>> >>>>> >>> >
