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 <mtus...@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 <ashok34...@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 > >
