hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Marcin Tustin <mtus...@handybook.com>
Subject Re: Updating column in table throws error
Date Sun, 06 Mar 2016 18:19:13 GMT
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