That helped. Thanks
On Wed, Mar 26, 2014 at 10:52 AM, Stephen Sprague <sprag...@gmail.com>wrote: > the error message is correct. remember the partition columns are not > stored with the data and by doing a "select *" that's what doing. And this > has nothing to do with ORC either its a Hive thing. :) > > so your second approach was close. just omit the partition columns yr, > mo, day. > > > On Wed, Mar 26, 2014 at 8:18 AM, P lva <ruvi...@gmail.com> wrote: > >> Hello, >> >> I'm trying to convert managed partitioned text table into compressed orc >> partitioned table. >> >> I created the a new table with the same schema but when I try inserting >> data the errors says there are different number of columns. >> >> I tried doing >> >> From table a insert into table b(yr=2014, mo=01, day=01 ) select * where >> yr='2014' and month='01' and day='01' >> >> Also tried doing this >> >> From table a insert into table b(yr=2014, mo=01, day=01) select >> a.column1, a.column2, a.column3, ....... where yr='2014' and month='01' and >> day='01' >> >> which didnt work either >> >> How does one copy data from a partitioned table to another along with >> partition information ? >> >> Thanks >> >> >> >> >> >> >> >> >> >
