hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Stephen Sprague <sprag...@gmail.com>
Subject Re: Partitioned table to partitioned table
Date Wed, 26 Mar 2014 15:52:31 GMT
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 <ruvikal@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
>
>
>
>
>
>
>
>
>

Mime
View raw message