You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hive.apache.org by Ashok Kumar <as...@yahoo.com> on 2016/03/06 19:03:44 UTC
Updating column in table throws error
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
Re: Updating column in table throws error
Posted by Mich Talebzadeh <mi...@gmail.com>.
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 <mt...@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 <as...@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
>
>
Re: Updating column in table throws error
Posted by Marcin Tustin <mt...@handybook.com>.
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 <as...@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