hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mich Talebzadeh <mich.talebza...@gmail.com>
Subject Re: Updating column in table throws error
Date Sun, 06 Mar 2016 19:12:24 GMT
Hi,

This update will throw an error as any column used for bucketing (read for
hash partitioning) cannot be updated as it is used for physical ordering of
rows in the table.

HTH

Dr Mich Talebzadeh



LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*



http://talebzadehmich.wordpress.com



On 6 March 2016 at 18:19, Marcin Tustin <mtustin@handybook.com> wrote:

> Don't bucket on columns you expect to update.
>
> Potentially you could delete the whole row and reinsert it.
>
>
> On Sunday, March 6, 2016, Ashok Kumar <ashok34668@yahoo.com> wrote:
>
>> Hi gurus,
>>
>> I have an ORC table bucketed on invoicenumber with "transactional"="true"
>>
>> I am trying to update invoicenumber column used for bucketing this table
>> but it comes back with
>>
>> Error: Error while compiling statement: FAILED: SemanticException [Error
>> 10302]: Updating values of bucketing columns is not supported.  Column
>> invoicenumber
>>
>> Any ideas how it can be solved?
>>
>> Thank you
>>
>
> 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
>
>

Mime
View raw message