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 0F6B618B62 for ; Fri, 26 Jun 2015 07:27:27 +0000 (UTC) Received: (qmail 64074 invoked by uid 500); 26 Jun 2015 07:27:25 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 64004 invoked by uid 500); 26 Jun 2015 07:27:25 -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 63994 invoked by uid 99); 26 Jun 2015 07:27:25 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 26 Jun 2015 07:27:25 +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 B9745C006D for ; Fri, 26 Jun 2015 07:27:24 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.9 X-Spam-Level: ** X-Spam-Status: No, score=2.9 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id Xf0Ofil6mI51 for ; Fri, 26 Jun 2015 07:27:15 +0000 (UTC) Received: from mail-la0-f48.google.com (mail-la0-f48.google.com [209.85.215.48]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id BA5B92092B for ; Fri, 26 Jun 2015 07:27:14 +0000 (UTC) Received: by lagi2 with SMTP id i2so58514515lag.2 for ; Fri, 26 Jun 2015 00:26:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=NTCcC+NfAPLIss8n54DrGyV3PFWcTyTMMUA74sHylps=; b=XiCPq6ujzbYh9TQ3+bVH9AF425gWNOifA/XMtOJzsFZOXyJ5bU34iMT33I0Zvkytcp F3yZmWI1MGqvxwMxIic+Dyv/E0aWtWQOm9abYb7z8ogkY2/3vj8BbtSVNM1iZQEIC7NZ q9QuoHLX7gWKGpNTvfkFuS+cAmphViVYxTEm5J9S8TFNJv7hMyti5XeuE59mXPgMEYgL 7KbMi3EDQUvdaNtXh0QRlhxrgVghl7oup86hNrfqEqv/giWMX3G2Lhm5K5Es8K7X/4vD u9qykkDVgn09Lk1o6fqdtICD6hXcASv2rpamla3r2vLj43zn3bzr2Id5GLT1ACqzIQnf lmpA== MIME-Version: 1.0 X-Received: by 10.112.132.9 with SMTP id oq9mr265636lbb.26.1435303582170; Fri, 26 Jun 2015 00:26:22 -0700 (PDT) Received: by 10.112.158.195 with HTTP; Fri, 26 Jun 2015 00:26:22 -0700 (PDT) In-Reply-To: References: <80CC0B37-269A-4BE9-9471-574CFFD719A9@digitalenvoy.net> <3435A715-13EE-469F-8F52-CBE7F1BDB327@digitalenvoy.net> Date: Fri, 26 Jun 2015 12:56:22 +0530 Message-ID: Subject: Re: EXPORTing multiple partitions From: Devopam Mittra To: "user@hive.apache.org" , sanjiv.is.on@gmail.com Content-Type: multipart/alternative; boundary=047d7b3a802c2905ab051966a802 --047d7b3a802c2905ab051966a802 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable +1 regards Dev On Fri, Jun 26, 2015 at 12:50 PM, @Sanjiv Singh wrote: > What about this : > > create view foo_copy_partition AS select * from foo where id in (1,2,3); > export table foo_copy_partition to =E2=80=98path=E2=80=99; > drop view foo_copy_partition ; > > > > > Regards > Sanjiv Singh > Mob : +091 9990-447-339 > > On Fri, Jun 26, 2015 at 7:40 AM, Xuefu Zhang wrote: > >> Hi Brian, >> >> If you think that is useful, please feel free to create a JIRA requestin= g >> for it. >> >> Thanks, >> Xuefu >> >> On Thu, Jun 25, 2015 at 10:36 AM, Brian Jeltema < >> brian.jeltema@digitalenvoy.net> wrote: >> >>> Answering my own question: >>> >>> create table foo_copy like foo; >>> insert into foo_copy partition (id) select * from foo where id in >>> (1,2,3); >>> export table foo_copy to =E2=80=98path=E2=80=99; >>> drop table foo_copy; >>> >>> It would be nice if export could do this automatically, though. >>> >>> Brian >>> >>> On Jun 25, 2015, at 11:34 AM, Brian Jeltema < >>> brian.jeltema@digitalenvoy.net> wrote: >>> >>> > Using Hive .13, I would like to export multiple partitions of a table= , >>> something conceptually like: >>> > >>> > EXPORT TABLE foo PARTITION (id=3D1,2,3) to =E2=80=98path=E2=80=99 >>> > >>> > Is there any way to accomplish this? >>> > >>> > Brian >>> >>> >> > --=20 Devopam Mittra Life and Relations are not binary --047d7b3a802c2905ab051966a802 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
+1=C2=A0

regards
Dev

On Fri, Jun 26= , 2015 at 12:50 PM, @Sanjiv Singh <sanjiv.is.on@gmail.com> wrote:
What about th= is :
=C2=A0
create view foo_copy_partition AS=C2=A0 select * f= rom foo where id in (1,2,3);
export table foo_copy_partition=C2=A0 to = =E2=80=98path=E2=80=99;
drop view foo_copy_partition ;




Regards
Sanjiv S= ingh
Mob :=C2=A0 +091 9990-447-339

On Fri, Jun 26, 2015 at 7:40 AM, Xuefu Zhang= <xzhang@cloudera.com> wrote:
Hi Brian,

If you think t= hat is useful, please feel free to create a JIRA requesting for it.

=
Thanks,
Xuefu
=
On Thu, Jun 25, 2015 at 10:36 AM, Brian Jelt= ema <brian.jeltema@digitalenvoy.net> wrote:
=
Answering my own question:

=C2=A0 create table foo_copy like foo;
=C2=A0 insert into foo_copy partition (id) select * from foo where id in (1= ,2,3);
=C2=A0 export table foo_copy to =E2=80=98path=E2=80=99;
=C2=A0 drop table foo_copy;

It would be nice if export could do this automatically, though.

Brian

On Jun 25, 2015, at 11:34 AM, Brian Jeltema <brian.jeltema@digitalenvoy.net= > wrote:

> Using Hive .13, I would like to export multiple partitions of a table,= something conceptually like:
>
>=C2=A0 =C2=A0EXPORT TABLE foo PARTITION (id=3D1,2,3) to =E2=80=98path= =E2=80=99
>
> Is there any way to accomplish this?
>
> Brian






--
Devopam Mittra
Life and Relations are not binary
--047d7b3a802c2905ab051966a802--