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 69470200B5D for ; Sun, 7 Aug 2016 15:19:44 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 67D68160A87; Sun, 7 Aug 2016 13:19:44 +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 84EFB160A6B for ; Sun, 7 Aug 2016 15:19:43 +0200 (CEST) Received: (qmail 2930 invoked by uid 500); 7 Aug 2016 13:19:42 -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 2920 invoked by uid 99); 7 Aug 2016 13:19:42 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 07 Aug 2016 13:19:42 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id D06FD1A0453 for ; Sun, 7 Aug 2016 13:19:41 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.18 X-Spam-Level: * X-Spam-Status: No, score=1.18 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=2, LOTS_OF_MONEY=0.001, 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: spamd2-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=handybook.com Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id q2Tq8QVqqAez for ; Sun, 7 Aug 2016 13:19:38 +0000 (UTC) Received: from mail-it0-f52.google.com (mail-it0-f52.google.com [209.85.214.52]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 8EB1D5F1F4 for ; Sun, 7 Aug 2016 13:19:38 +0000 (UTC) Received: by mail-it0-f52.google.com with SMTP id u186so55646517ita.0 for ; Sun, 07 Aug 2016 06:19:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=handybook.com; s=google; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=blMfh76h34rOjbetHHQh9kzCnTUfCRweoHbOvc+NPXU=; b=PLtqWQb+ruiB5GVZvK9iLpKmWExh+QtNyD7MLkMZJIsGtG07rqEQGDY3GdWVdigmCp ndL31D6lOO0aKSciWu4xg23trYsn4twloAAfQG6ImeoVrF8FK++i/UDF/8Tjf49iVO6d w5hj5dc24TZYnnCdKP1cbIzIaexAG+cwf/7JY= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=blMfh76h34rOjbetHHQh9kzCnTUfCRweoHbOvc+NPXU=; b=T1wSMyf+8TIkwy4BnbmPeuNDQiLyhyxBteUbwG3phmZfKn5IMT8GdR2SxEXhzWGsWI wvD5SLRw7blh9jGB6zeSXIbfLZ89tFCrtebomkm87wA657tiGrnCaRKI2Mw1Yp8ILeqH 9P7vqABe/a3UY83Y8dN/+1w25fpn8HvMYpFJ050zLxpzqkfC6HCPNzHQz22V1kl1+O5x mhxSigypdQ9C5q1cGN0Qifsv3mpVJTYrDGciDKyHwAGtN4YMUrwSiui40eJG0PaZrDGQ rFPfSyY+ZF5ahA+BUxmjA6HbMKHd9473ZmvUWboMZ0FR9oXao5p/ipxn0fC5NwHyhiY3 2fbA== X-Gm-Message-State: AEkooutP8Lmx/kdu9Z/Vz6Ck/9Lj5NKdINcnOwt7jcHam+AsWezbmgdSl3JFX11FLEeq5Tg/tCmntlLzfaQFrbAD0zRgfs+GKJ2u6F6x5ya3oYqZv70LkfqhHKgSNpzMHAcz9CELHjW1h+38TY/ZESsU9Ug0zGYob1Q0SL5KHEXDCBsd+M8bQLD/FOuzVGpbTl6Ggker+YFo/xg= X-Received: by 10.36.19.75 with SMTP id 72mr12886032itz.83.1470575971897; Sun, 07 Aug 2016 06:19:31 -0700 (PDT) MIME-Version: 1.0 Received: by 10.79.115.212 with HTTP; Sun, 7 Aug 2016 06:19:11 -0700 (PDT) In-Reply-To: References: From: Marcin Tustin Date: Sun, 7 Aug 2016 09:19:11 -0400 Message-ID: Subject: Re: Crate Non-partitioned table from partitioned table using CREATE TABLE .. LIKE To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a1145180a6bb14405397b269f archived-at: Sun, 07 Aug 2016 13:19:44 -0000 --001a1145180a6bb14405397b269f Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Why exclude the partition column? It will still be unpartitioned whether or not the partition column is excluded. On Sun, Aug 7, 2016 at 8:23 AM, Markovitz, Dudu wrote: > It won=E2=80=99t help him since =E2=80=98*=E2=80=99 represent all columns= including the partition > columns which he wants to exclude. > > > > Dudu > > > > *From:* Marcin Tustin [mailto:mtustin@handybook.com] > *Sent:* Sunday, August 07, 2016 3:17 PM > *To:* user@hive.apache.org > *Subject:* Re: Crate Non-partitioned table from partitioned table using > CREATE TABLE .. LIKE > > > > Will CREATE TABLE sales5 AS SELECT * FROM SALES; not work for you? > > > > On Thu, Aug 4, 2016 at 5:05 PM, Nagabhushanam Bheemisetty < > nbheemisetty@gmail.com> wrote: > > Hi I've a scenario where I need to create a table from partitioned table > but my destination table should not be partitioned. I won't be knowing th= e > schema so I cannot create manually the destination table. By the way both > tables are external tables. > > > > > > Want to work at Handy? Check out our culture deck and open roles > > > Latest news at Handy > > Handy just raised $50m > led > by Fidelity > > > > --=20 Want to work at Handy? Check out our culture deck and open roles=20 Latest news at Handy Handy just raised $50m=20 led=20 by Fidelity --001a1145180a6bb14405397b269f Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Why exclude the partition column? It will still be unparti= tioned whether or not the partition column is excluded.=C2=A0

On Sun, Aug 7, 2016 at 8:= 23 AM, Markovitz, Dudu <dmarkovitz@paypal.com> wrote:

It won=E2=80=99t help him since =E2= =80=98*=E2=80=99 represent all columns including the partition columns whic= h he wants to exclude.

=C2=A0

Dudu

=C2=A0

From: Marcin Tustin [mailto:mtustin@handybook.com]
Sent: Sunday, August 07, 2016 3:17 PM
To: user@h= ive.apache.org
Subject: Re: Crate Non-partitioned table from partitioned table usin= g CREATE TABLE .. LIKE

=C2=A0

Will=C2=A0CREATE TABLE sales5 AS SELECT * FROM S= ALES; not work for you?

=C2=A0

On Thu, Aug 4, 2016 at 5:05 PM, Nagabhushanam Bheemi= setty <nbhee= misetty@gmail.com> wrote:

Hi I've a scenario where I need to create a tabl= e from partitioned table but my destination table should not be partitioned= . I won't be knowing the schema so I cannot create manually the destina= tion table. By the way both tables are external tables.

=C2=A0

=C2=A0

Want to work= at Handy? Check out our=C2=A0culture deck and open roles

Latest=C2=A0= news=C2=A0at H= andy

Handy=C2=A0<= a href=3D"http://venturebeat.com/2015/11/02/on-demand-home-service-handy-ra= ises-50m-in-round-led-by-fidelity/" target=3D"_blank">just raised $50m=C2=A0led by Fidelity

=C2=A0



Want to work at Han= dy? Check out our=C2=A0culture deck and open r= oles
Latest=C2=A0news=C2= =A0at Handy
Handy=C2=A0just raised $50m=C2=A0led by Fidelity

--001a1145180a6bb14405397b269f--