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
