Return-Path: Delivered-To: apmail-hadoop-hive-dev-archive@minotaur.apache.org Received: (qmail 50170 invoked from network); 23 Jul 2010 10:25:49 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 23 Jul 2010 10:25:49 -0000 Received: (qmail 67019 invoked by uid 500); 23 Jul 2010 10:25:49 -0000 Delivered-To: apmail-hadoop-hive-dev-archive@hadoop.apache.org Received: (qmail 66832 invoked by uid 500); 23 Jul 2010 10:25:47 -0000 Mailing-List: contact hive-dev-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hadoop.apache.org Delivered-To: mailing list hive-dev@hadoop.apache.org Received: (qmail 66277 invoked by uid 99); 23 Jul 2010 10:25:47 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Jul 2010 10:25:47 +0000 X-ASF-Spam-Status: No, hits=0.7 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [202.144.10.51] (HELO orcon.sify.net) (202.144.10.51) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Jul 2010 10:25:38 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by orcon.sify.net (Postfix) with ESMTP id 3642941A1F9 for ; Fri, 23 Jul 2010 15:53:53 +0530 (IST) X-Virus-Scanned: amavisd-new at example.com Received: from orcon.sify.net ([127.0.0.1]) by localhost (orcon.sify.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id N5ogzQsWWVeQ for ; Fri, 23 Jul 2010 15:53:52 +0530 (IST) Received: from mail1.mkhoj.com (mx.mkhoj.com [210.210.41.205]) by orcon.sify.net (Postfix) with ESMTP id 8B22D413567 for ; Fri, 23 Jul 2010 15:53:52 +0530 (IST) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AlcFAOsJSUwKDmQH/2dsb2JhbACgUQbAe4U2BIQDhF2COg X-IronPort-AV: E=Sophos;i="4.55,246,1278268200"; d="scan'208";a="847310" Received: from mk-exch-1.mkhoj.com ([10.14.100.7]) by mail1.mkhoj.com with ESMTP; 23 Jul 2010 15:53:49 +0530 Received: from [10.14.100.183] (10.14.100.183) by MK-EXCH-1.MKHOJ.COM (10.14.100.7) with Microsoft SMTP Server id 8.1.340.0; Fri, 23 Jul 2010 15:51:19 +0530 Message-ID: <4C496DAD.8070301@mkhoj.com> Date: Fri, 23 Jul 2010 15:53:41 +0530 From: jaydeep vishwakarma User-Agent: Thunderbird 2.0.0.23 (X11/20090817) MIME-Version: 1.0 To: "hive-dev@hadoop.apache.org" Subject: Append data by insert command Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org Hi, Not able to append data in hive tables .I know only one syntax of "INSERT" command which have keyword called "OVERWRITE" , It overwrites data in whole partition. Is there any other way by that I can append records in hive tables by HQL? Regards, Jaydeep The information contained in this communication is intended solely for the = use of the individual or entity to whom it is addressed and others authoriz= ed to receive it. It may contain confidential or legally privileged informa= tion. If you are not the intended recipient you are hereby notified that an= y disclosure, copying, distribution or taking any action in reliance on the= contents of this information is strictly prohibited and may be unlawful. I= f you have received this communication in error, please notify us immediate= ly by responding to this email and then delete it from your system. The fir= m is neither liable for the proper and complete transmission of the informa= tion contained in this communication nor for any delay in its receipt.