Why exclude the partition column? It will still be unpartitioned whether or not the partition column is excluded.
On Sun, Aug 7, 2016 at 8:23 AM, Markovitz, Dudu <dmarkov...@paypal.com> wrote: > It won’t help him since ‘*’ represent all columns including the partition > columns which he wants to exclude. > > > > Dudu > > > > *From:* Marcin Tustin [mailto:mtus...@handybook.com] > *Sent:* Sunday, August 07, 2016 3:17 PM > *To:* user@hive.apache.org > *Subject:* Re: Crate Non-partitioned table from partitioned table using > CREATE TABLE .. LIKE > > > > Will CREATE TABLE sales5 AS SELECT * FROM SALES; not work for you? > > > > On Thu, Aug 4, 2016 at 5:05 PM, 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. > > > > > > 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 > > > > -- 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
