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 <[email protected]> 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 < > [email protected]> 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. >> > >
