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 B852410504 for ; Wed, 16 Oct 2013 06:57:39 +0000 (UTC) Received: (qmail 48685 invoked by uid 500); 16 Oct 2013 06:57:33 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 48622 invoked by uid 500); 16 Oct 2013 06:57:31 -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 48611 invoked by uid 99); 16 Oct 2013 06:57:28 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Oct 2013 06:57:28 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of nitinpawar432@gmail.com designates 209.85.128.43 as permitted sender) Received: from [209.85.128.43] (HELO mail-qe0-f43.google.com) (209.85.128.43) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Oct 2013 06:57:22 +0000 Received: by mail-qe0-f43.google.com with SMTP id nc12so261385qeb.16 for ; Tue, 15 Oct 2013 23:57:02 -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=rG05XVNML8yKOw8ua0rpnCu9zQ5XVhkVqoI61cTlJgw=; b=mD6IwckYEWq7W5/2WxedmoeogX/YqPfCk39sA6bAFbgIQYBAFF19jDtPK4Cvr3yG/F YmSI4GOhd71zkOQrdRhKT/gh5QxJuyEJLiYPgR1LVPBnZ1KUtT3ONTNXK2HG7quMOmcf M/f29lp+J4E8mYtuugyj0BaU5Cv84GfwPsq44vnkasjKZ4Ww2J4L7gIeAsDa7KGKpYZp CUS3YoIaYA01pVtuQ7DMgyRXpnzlQ1qXqTqtGzrb76oaiBPgPPFdB18jcjXMX2YCLrpp TXep2lXwgMRLllvywmnzVTu6N3ZKOxFqZSYozizD/Q7O6S22MRrwNg50zvh0xMk/dYjb +Ykg== MIME-Version: 1.0 X-Received: by 10.224.171.67 with SMTP id g3mr2432003qaz.13.1381906622043; Tue, 15 Oct 2013 23:57:02 -0700 (PDT) Received: by 10.224.193.136 with HTTP; Tue, 15 Oct 2013 23:57:01 -0700 (PDT) In-Reply-To: References: Date: Wed, 16 Oct 2013 12:27:01 +0530 Message-ID: Subject: Re: Create table as select From: Nitin Pawar To: "user@hive.apache.org" Content-Type: multipart/alternative; boundary=047d7b67768851de3e04e8d63595 X-Virus-Checked: Checked by ClamAV on apache.org --047d7b67768851de3e04e8d63595 Content-Type: text/plain; charset=ISO-8859-1 Hive 0.12 is just released today and I still have not got my hands on it. But the query you are trying works on hive-0.11 Hive dev team works extremely hard to keep backward compatibility so it should work on hive-0.12 If you face any issues do file a JIRA :) On Wed, Oct 16, 2013 at 11:18 AM, Adline Dsilva wrote: > Hi All, > > Does hive (0.12) support sql statement "create TABLE tmp_table AS > select * from user_table limit 500". Currently I'm running 0.10 version, > where its not supported. > > Regards, > Adline -- Nitin Pawar --047d7b67768851de3e04e8d63595 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable
Hive 0.12 is just released today and I still have not got = my hands on it. But the query you are trying works on hive-0.11

Hive dev team works extremely hard to keep backward compatibility s= o it should work on hive-0.12

If you face any issues do file a JIRA :)=A0
=


On Wed, Oct 1= 6, 2013 at 11:18 AM, Adline Dsilva <adline.dsilva@mimos.my> wrote:
Hi All,

=A0 Does hive (0.12) support =A0sql statement "create TABLE tmp_table = AS select * from user_table limit 500". Currently I'm running 0.10= version, where its not supported.

Regards,
Adline



--
Nitin = Pawar
--047d7b67768851de3e04e8d63595--