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 18859113DD for ; Fri, 6 Jun 2014 09:56:15 +0000 (UTC) Received: (qmail 13726 invoked by uid 500); 6 Jun 2014 09:56:13 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 13651 invoked by uid 500); 6 Jun 2014 09:56:13 -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 13643 invoked by uid 99); 6 Jun 2014 09:56:13 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Jun 2014 09:56:13 +0000 X-ASF-Spam-Status: No, hits=3.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_BL_SPAMCOP_NET,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of knowledge.gatherer.007@gmail.com designates 209.85.216.67 as permitted sender) Received: from [209.85.216.67] (HELO mail-qa0-f67.google.com) (209.85.216.67) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 06 Jun 2014 09:56:09 +0000 Received: by mail-qa0-f67.google.com with SMTP id cm18so995376qab.2 for ; Fri, 06 Jun 2014 02:55:45 -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=QcyReiTe/eVD3RIgEKSMvGgSb/yzWLZTcf3gkMWv4ik=; b=b7Q4K0xDqNnYGkyzoA7nRqG49VkfNuq475vp1MaU9xUv3Um2HdcABv0zM/AYMTkSVB zUTwuLGfSLy438lmJ59/hQBp86PtQrAefD1h7ssLOLI1BIsK5VI0565fefhT4Os2kpOi Gs4gMN4fknRDI5A/J7LnNGbqRsT5m2jKEPiWJiFYCVaieNpmCEOylm+Z0oqykVMXfVEr 8peg8T891BnJJXThV7xnUf1B7wSHexGbz7T+OSk5vk/oQTdI6HrtHy/NHqG89bK/+ENg olVc+HDX5oD8bw6MDj0U8BT8OgVSDtMwbkEimDaU/3AszJnJXbG5/T0aUt0/cQyJbyNz URMQ== MIME-Version: 1.0 X-Received: by 10.224.0.70 with SMTP id 6mr6727225qaa.100.1402048545413; Fri, 06 Jun 2014 02:55:45 -0700 (PDT) Received: by 10.170.67.87 with HTTP; Fri, 6 Jun 2014 02:55:45 -0700 (PDT) In-Reply-To: References: Date: Fri, 6 Jun 2014 15:25:45 +0530 Message-ID: Subject: Re: Storing and reading XML files in HIVE From: Knowledge gatherer To: user@hive.apache.org Content-Type: multipart/alternative; boundary=047d7bdc96c881f9d504fb27dddf X-Virus-Checked: Checked by ClamAV on apache.org --047d7bdc96c881f9d504fb27dddf Content-Type: text/plain; charset=UTF-8 U need to have a CustomSerde in Hive to read the XML files On Fri, Jun 6, 2014 at 2:58 PM, Yu Azuryy wrote: > AFAIK, Hive doesn't provide XMLInputFormat , so you had to write it by > yourself. > > > On Fri, Jun 6, 2014 at 5:23 PM, Ramasubramanian Narayanan < > ramasubramanian.narayanan@gmail.com> wrote: > >> Dear All, >> >> Request your help to guide how to store and read XML data in HIVE. >> >> while querying it should look as if we are having txt format file under >> HIVE (it is fine if we use view to parse the XML and show). >> >> Have gone through some sites but not able to figure out correctly.. few >> are mentioning that we need use some JAR's to achieve it... >> >> >> Thanks in advance, >> Rams >> > > --047d7bdc96c881f9d504fb27dddf Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
U need to have a CustomSerde in Hive to read the XML files=


On Fri,= Jun 6, 2014 at 2:58 PM, Yu Azuryy <azuryy.yfd@gmail.com>= wrote:
AFAIK, Hive doesn't pro= vide XMLInputFormat , so you had to write it by yourself.


On Fri, Jun 6, 2014 at 5:23 PM, Ramasubramanian Narayanan <ramasubramanian.narayanan@gmail.com> wrote:
Dear All,

Request your help to guide how to store and read XML data in HIVE.
<= div>
while querying it should look as if we are having txt format= file under HIVE (it is fine if we use view to parse the XML and show).

Have gone through some sites but not able to figu= re out correctly.. few are mentioning that we need use some JAR's to ac= hieve it...


Thanks in advance,
Rams


--047d7bdc96c881f9d504fb27dddf--