Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 948AA200B16 for ; Mon, 6 Jun 2016 05:02:28 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 92E28160A53; Mon, 6 Jun 2016 03:02:28 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id D9E54160A28 for ; Mon, 6 Jun 2016 05:02:27 +0200 (CEST) Received: (qmail 76482 invoked by uid 500); 6 Jun 2016 03:02:26 -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 76471 invoked by uid 99); 6 Jun 2016 03:02:25 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Jun 2016 03:02:25 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 5F73EC3184 for ; Mon, 6 Jun 2016 03:02:25 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.179 X-Spam-Level: * X-Spam-Status: No, score=1.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd1-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id PAGbQINURtZy for ; Mon, 6 Jun 2016 03:02:24 +0000 (UTC) Received: from mail-vk0-f65.google.com (mail-vk0-f65.google.com [209.85.213.65]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 752705FB76 for ; Mon, 6 Jun 2016 03:02:24 +0000 (UTC) Received: by mail-vk0-f65.google.com with SMTP id x7so5417897vkf.3 for ; Sun, 05 Jun 2016 20:02:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:from:date:message-id:subject:to; bh=riRELyig6ee3XmqthQ2/H5IBzoGyVi8WLgZwb3B3wXc=; b=x6GnwZK8N0iqgjt1Rs6oUgpo+PsqZkGwhcfIQZvg5QIEyb0C07huEpFKr/vhCYpsx8 7jKYrsp0Qo/Qo/Eshzz0mcmiiwA3BY24Vw96NzEzBu7o1XkYoJPiveo5IjS+Ytf2roTu kK08UHiB9Tz7hhsDSp0pYspeRsq00UxX3PMVzQ2/oaf46i3YYqVW8kWUYs97OPrWxEs/ N/9raaB1IC8y5+Zz/VW8QIeJhw7JVG0JHIIVWe4/wzQrQjIP3CMNPTBG/5+8oc2mqiTP vhj7ZCJtrmMZltJP5FNjdvYR4M9wWKpZ71x6xj6eCduKtRISnVU4vMtzNxic3b3rIzKH pZxw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=riRELyig6ee3XmqthQ2/H5IBzoGyVi8WLgZwb3B3wXc=; b=AinHW23sGl56p5CcNSW7kmWu0w/8+Jj5gsbmoXc6St0AyOM6FLVYwM+wd//LNhLVLe DgQIt23C4MZGravw7r5j1nJu2xt6bm0rZbgQ9Ydv1omGEP7hN7mhOqbmZhXnYP1LSX8C j4C5qlMrLOErDVRB3Z2W1fKHqvSfjl1Q4eF5k7Ci9LvJIRDgUV6xMhONqXD7T4l5Bv7/ I5WV4/sdWvCEai1bZictVGK6jho6EW7LalHX2cT7etSjEyvMbGGt/DDUOhr7qc4Z+zJ5 +LP+rzZ8d6hX86nNgf4yuH7/x5WZpUnN8vre5KBxtsWO9Ylfl4CNLentlx+dRMcgd0f6 KvNA== X-Gm-Message-State: ALyK8tL7+8hKK7HGc37zE3n33t2ybTKBzDO6D0rr5LYh+AScf2A8LebCFhTdwM4vajH+zpliPP9al34FWRovKw== X-Received: by 10.31.5.143 with SMTP id 137mr6884689vkf.48.1465182138259; Sun, 05 Jun 2016 20:02:18 -0700 (PDT) MIME-Version: 1.0 Received: by 10.31.8.140 with HTTP; Sun, 5 Jun 2016 20:02:17 -0700 (PDT) From: raj hive Date: Mon, 6 Jun 2016 08:32:17 +0530 Message-ID: Subject: alter partitions on hive external table To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a1143ccf0e1df520534934ca6 archived-at: Mon, 06 Jun 2016 03:02:28 -0000 --001a1143ccf0e1df520534934ca6 Content-Type: text/plain; charset=UTF-8 Hi friends, I have created partitions on hive external tables. partitions on datetime/userid/customerId. now i have to change the order of the partitions for the existing data for all the dates. order of the partition is custerid/userid/datetime. Anyone can help me, how to alter the partitions for the existing table. Need a help to write a script to change the partions on existing data. almost 3 months data is there to modify as per new partition so changing each date is difficult. Any expert can help me. Thanks Raj --001a1143ccf0e1df520534934ca6 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi friends,

I h= ave created partitions on hive external tables. partitions on datetime/user= id/customerId.

now i have to change the order of the partition= s for the existing data for all the dates.

order of the partit= ion is custerid/userid/datetime.

Anyone can help me, how to al= ter the partitions for the existing table. Need a help to write a script to= change the partions on existing data. almost 3 months data is there to mod= ify as per new partition so changing each date is difficult. Any expert can= help me.

Thanks
Raj
--001a1143ccf0e1df520534934ca6--