Return-Path: 
 <user-return-15227-apmail-hadoop-common-user-archive=hadoop.apache.org@hadoop.apache.org>
X-Original-To: apmail-hadoop-common-user-archive@www.apache.org
Delivered-To: apmail-hadoop-common-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 4299B10A7E
	for <apmail-hadoop-common-user-archive@www.apache.org>;
 Wed, 30 Apr 2014 09:44:47 +0000 (UTC)
Received: (qmail 36852 invoked by uid 500); 30 Apr 2014 09:44:38 -0000
Delivered-To: apmail-hadoop-common-user-archive@hadoop.apache.org
Received: (qmail 36179 invoked by uid 500); 30 Apr 2014 09:44:30 -0000
Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hadoop.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hadoop.apache.org>
List-Post: <mailto:user@hadoop.apache.org>
List-Id: <user.hadoop.apache.org>
Reply-To: user@hadoop.apache.org
Delivered-To: mailing list user@hadoop.apache.org
Received: (qmail 36069 invoked by uid 99); 30 Apr 2014 09:44:28 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 30 Apr 2014 09:44:28 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of alajangikishore@gmail.com
 designates 209.85.213.46 as permitted sender)
Received: from [209.85.213.46] (HELO mail-yh0-f46.google.com) (209.85.213.46)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 30 Apr 2014 09:44:24 +0000
Received: by mail-yh0-f46.google.com with SMTP id c41so1375821yho.33
        for <user@hadoop.apache.org>; Wed, 30 Apr 2014 02:44:01 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type;
        bh=yK1xEHENeKOpZl9MePkB3RfRKeezSPsdFjbtsaIuGdA=;
        b=KBlj3saFcAn44bfx2UQEX3lkK5SRznK7eKmjpQk7WO0/ku4FTphttAUTS57/Eg3CUr
         Mh5gLgWnneZGa5pmWSMdHCVhbLnZ8AO+2yDqk2Qjzbsqr3hTZiXcMzkQ1Dj/nPMDU28C
         L6l+trsLBX1l3juXF9PXr+N5/BuO+dAE/hCckLQxbL3zrblHrp0UbULwRMS7Ue1ecRdv
         wjohhoNnCO07fAMk9OE8f2gynzLgNAntfrKkW8Vy63cvs6Ei3BEqH44GhUq3gtyafklL
         HjQaswv5TBRf8JUF7Bk/R8vmGqyCxhF5jzm5Zmaq8LeGu/Cr0ia5H+1sDewmubpOMR8E
         745g==
MIME-Version: 1.0
X-Received: by 10.236.1.3 with SMTP id 3mr4217161yhc.62.1398851041204; Wed, 30
 Apr 2014 02:44:01 -0700 (PDT)
Received: by 10.170.142.3 with HTTP; Wed, 30 Apr 2014 02:44:01 -0700 (PDT)
Date: Wed, 30 Apr 2014 15:14:01 +0530
Message-ID: 
 <CAHv0dggVtJY0UoOkqERe8azjtEoWjgEUsGqOd9YL7j1mfM2ZPg@mail.gmail.com>
Subject: Hive table creation to support multiple delimiters
From: kishore alajangi <alajangikishore@gmail.com>
To: user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=001a1133391267a33c04f83f638f
X-Virus-Checked: Checked by ClamAV on apache.org

--001a1133391267a33c04f83f638f
Content-Type: text/plain; charset=ISO-8859-1

Hi All,

My input data looks like below as | delimited and I want to extract appid,
appname, bundleid etc, please help me to create hive table ,

|0|{\x22appid\x22:\x228\x22,\x22appname\x22:\x22CONVX-0008\x22,\x22bundleid\x22:\x22com.zeptolab.timetravel.free.google\x22}|14|


-- 
Thanks,
Kishore.

--001a1133391267a33c04f83f638f
Content-Type: text/html; charset=ISO-8859-1

<div dir="ltr">Hi All,<br><br>My input data looks like below as | delimited 
and I want to extract appid, appname, bundleid etc, please help me to 
create hive table ,<br><br>


	
	
	
	


<p style="margin-bottom:0in;font-weight:normal">|0|{\x22appid\x22:\x228\x22,\x22appname\x22:\x22CONVX-0008\x22,\x22bundleid\x22:\x22com.zeptolab.timetravel.free.google\x22}|14|</p><br clear="all"><br>-- <br>Thanks,<br>Kishore.
</div>

--001a1133391267a33c04f83f638f--