Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7C48D1870D for ; Sun, 6 Mar 2016 18:03:56 +0000 (UTC) Received: (qmail 90899 invoked by uid 500); 6 Mar 2016 18:03:54 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 90825 invoked by uid 500); 6 Mar 2016 18:03:54 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 90815 invoked by uid 99); 6 Mar 2016 18:03:54 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 06 Mar 2016 18:03:54 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 137A7C0679 for ; Sun, 6 Mar 2016 18:03:54 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.369 X-Spam-Level: * X-Spam-Status: No, score=1.369 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_ENVFROM_END_DIGIT=0.25, FREEMAIL_REPLYTO_END_DIGIT=0.25, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H2=-0.001, RP_MATCHES_RCVD=-0.329, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=yahoo.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id E5J6ps4TagM7 for ; Sun, 6 Mar 2016 18:03:52 +0000 (UTC) Received: from nm31-vm5.bullet.mail.ir2.yahoo.com (nm31-vm5.bullet.mail.ir2.yahoo.com [212.82.97.92]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 3B5445F3F2 for ; Sun, 6 Mar 2016 18:03:52 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1457287425; bh=WKd5l66HI9d3XytPrMsE8jiXTjIWmxDlSX4/jf4oXgo=; h=Date:From:Reply-To:To:Subject:References:From:Subject; b=Dz0URMGAEH21QcBhIiIlz5CSdC1sowL2nHoswNTM9b06a51/h+LdGepnp6T8W9dop/+e3zUJTXRFgyM+HRWh/eTIqA/x+8qk3HEJ8OQKHH56HI2ujGrCfG8u30F/sclg+LKaomJUwDpMr/jNCxs33TH1xGcWef3MgLPlNGvCbePpPILgz9L3rO8mH9PjkfW2QawMZ/xS9uoIeFGOAgP/sJ+Zo8MYlsEa/6+Z0m5IQf77b7SJVvsLeHwowcKknViBofO7jCjW1eK9yYpLsQZUY/bEyifueebMQ2kRBbejRoC41eEj32D4lvvJo8IVTdfUDzf6lRW4Pf+Bn9os9384lw== Received: from [212.82.98.52] by nm31.bullet.mail.ir2.yahoo.com with NNFMP; 06 Mar 2016 18:03:45 -0000 Received: from [212.82.98.72] by tm5.bullet.mail.ir2.yahoo.com with NNFMP; 06 Mar 2016 18:03:45 -0000 Received: from [127.0.0.1] by omp1009.mail.ir2.yahoo.com with NNFMP; 06 Mar 2016 18:03:45 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 511531.65523.bm@omp1009.mail.ir2.yahoo.com X-YMail-OSG: xpLFG3kVM1lKRzK8nsdnA3HPXjLuaX5S3TKdfnlzDm7e14Vh4mwZdcSJpLAYIDi yoTxIHLtxJ383zXJ_Xf5RT5IR9DpT2a4wraRIHPRBB3.6mbWp0ntCDDTHhTq.sPnfX6bYKl2vs_3 FF_jJXfi2NuRA9RRJDslc1Vk3UZ_.N_609fRZAd0Ae6dz3CqfwrgYGh5kZZq26fXytVx3UFZomSj 8VyQBBvU6zNjdKLcUvCEt1FBMUNH.FuKmbn9KjCCcBaSdlc_PD7KWX4wXQKfcdtN6YGCYTwcA4zK xbD.kg_Azl704M_uPqqLVYUMdWsJJMw2P8cVWtIOvk7JcqOyKhzgvobdoS9w41X9NziZYPhaQK3h dT0zwXfipCsJOLszK5wuE01exgNutXUS81jcegVzSow6ZS.ChQFPII3ac4hI7IpfujWUCJeWA9Hb 5ikDpjY_Za5yKF_BX.pj9mwsv4VabeIL9U3ABVEjDRZygAPD4oFy_y2ml_lTdE.YWM0Tt89HFi46 CaSg0b9M- Received: by 217.12.9.13; Sun, 06 Mar 2016 18:03:45 +0000 Date: Sun, 6 Mar 2016 18:03:44 +0000 (UTC) From: Ashok Kumar Reply-To: Ashok Kumar To: User Message-ID: <994090007.6772469.1457287424776.JavaMail.yahoo@mail.yahoo.com> Subject: Updating column in table throws error MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6772468_1794594222.1457287424773" References: <994090007.6772469.1457287424776.JavaMail.yahoo.ref@mail.yahoo.com> ------=_Part_6772468_1794594222.1457287424773 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi gurus, I have an ORC table bucketed on invoicenumber with "transactional"=3D"true" I am trying to update invoicenumber column used for bucketing this table bu= t it comes back with Error: Error while compiling statement: FAILED: SemanticException [Error 10= 302]: Updating values of bucketing columns is not supported.=C2=A0 Column i= nvoicenumber Any ideas how it can be solved? Thank you ------=_Part_6772468_1794594222.1457287424773 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi gurus,

I have an ORC table bucketed on invoicenumber with "transa= ctional"=3D"true"

I am trying to update invoi= cenumber column used for bucketing this table but it comes back with
<= div id=3D"yui_3_16_0_1_1457215426848_24989">
Error: Error while compiling statement: FAILED: Sem= anticException [Error 10302]: Updating values of bucketing columns is not s= upported.  Column invoicenumber

Any ideas how it can be solved?

Thank you
------=_Part_6772468_1794594222.1457287424773--