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 D04B910B09 for ; Wed, 9 Jul 2014 16:20:42 +0000 (UTC) Received: (qmail 65544 invoked by uid 500); 9 Jul 2014 16:20:41 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 65477 invoked by uid 500); 9 Jul 2014 16:20:41 -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 65464 invoked by uid 99); 9 Jul 2014 16:20:41 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Jul 2014 16:20:41 +0000 X-ASF-Spam-Status: No, hits=-0.1 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of Manish.Kothari@vonage.com designates 69.59.255.142 as permitted sender) Received: from [69.59.255.142] (HELO Mail-ob-360a.kewr1.m.vonagenetworks.net) (69.59.255.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 09 Jul 2014 16:20:36 +0000 X-IronPort-AV: E=Sophos;i="5.01,632,1400040000"; d="scan'208,217";a="28977793" Received: from unknown (HELO NJ-CAS-HUB3.vonage.net) ([10.111.155.104]) by Mail-ob-360a.kewr1.m.vonagenetworks.net with ESMTP/TLS/AES128-SHA; 09 Jul 2014 12:24:07 -0400 Received: from NJ-MBX1.vonage.net ([fe80::c8e2:d5ea:cbd0:1788]) by NJ-CAS-HUB3.vonage.net ([::1]) with mapi id 14.03.0181.006; Wed, 9 Jul 2014 12:20:11 -0400 From: Manish Kothari To: "user@hive.apache.org" Subject: Error while renaming Partitioned column name Thread-Topic: Error while renaming Partitioned column name Thread-Index: Ac+bkaaeU7spnr1MR0KgfsdQbo3BiA== Date: Wed, 9 Jul 2014 16:20:10 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [10.111.50.49] Content-Type: multipart/alternative; boundary="_000_D23386570CCF5547BC5598B627D066EE0A36E2CBNJMBX1vonagenet_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_D23386570CCF5547BC5598B627D066EE0A36E2CBNJMBX1vonagenet_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I have a table name siplogs_partitioned which is partitioned by columns str= _date(DATE) and str_hour(INT). I want to rename the partitioned columns to = call_date and call_hour. I am using the below command to alter the partitioned column name: - ALTER TABLE siplogs_partitioned PARTITION str_date RENAME TO PARTITION call= _date; When I run the above command I am getting an error : - FAILED: ParseException line 1:12 cannot recognize input near 'siplogs_parti= tioned' 'PARTITION' 'str_date' in alter table partition statement Is the "ALTER TABLE" usage correct to rename the partitioned column names? Any pointer or help is appreciated. Thanks, Manish --_000_D23386570CCF5547BC5598B627D066EE0A36E2CBNJMBX1vonagenet_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

I have a table name siplogs_partitioned which is par= titioned by columns str_date(DATE) and str_hour(INT). I want to rename the = partitioned columns to call_date and call_hour.

I am using the below command to alter the partitione= d column name: -

ALTER TABLE siplogs_partitioned PARTITION str_date R= ENAME TO PARTITION call_date;

When I run the above command I am getting an error := -

FAILED: ParseException line 1:12 cannot recognize in= put near 'siplogs_partitioned' 'PARTITION' 'str_date' in alter table partit= ion statement

Is the “ALTER TABLE” usage correct to re= name the partitioned column names?

Any pointer or help is appreciated.

Thanks,

Manish

--_000_D23386570CCF5547BC5598B627D066EE0A36E2CBNJMBX1vonagenet_--