hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From P lva <ruvi...@gmail.com>
Subject Re: Partitioned table to partitioned table
Date Wed, 26 Mar 2014 20:36:24 GMT
That helped. Thanks



On Wed, Mar 26, 2014 at 10:52 AM, Stephen Sprague <spragues@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 <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