Return-Path: X-Original-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Delivered-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id D9FCE4083 for ; Thu, 23 Jun 2011 03:04:36 +0000 (UTC) Received: (qmail 69466 invoked by uid 500); 23 Jun 2011 03:04:36 -0000 Delivered-To: apmail-hadoop-mapreduce-user-archive@hadoop.apache.org Received: (qmail 69106 invoked by uid 500); 23 Jun 2011 03:04:31 -0000 Mailing-List: contact mapreduce-user-help@hadoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: mapreduce-user@hadoop.apache.org Delivered-To: mailing list mapreduce-user@hadoop.apache.org Received: (qmail 69095 invoked by uid 99); 23 Jun 2011 03:04:28 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Jun 2011 03:04:28 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,MIME_QP_LONG_LINE,RCVD_IN_DNSWL_LOW,RFC_ABUSE_POST,SPF_PASS,T_TO_NO_BRKTS_FREEMAIL X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of mapred.learn@gmail.com designates 209.85.210.48 as permitted sender) Received: from [209.85.210.48] (HELO mail-pz0-f48.google.com) (209.85.210.48) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Jun 2011 03:04:19 +0000 Received: by pzk10 with SMTP id 10so1239151pzk.35 for ; Wed, 22 Jun 2011 20:03:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:subject:references:from:content-type:x-mailer :message-id:date:to:content-transfer-encoding:mime-version; bh=Ng8MsiHuZq6hKzmlsKeucZL2Hb4G5aakmvL2PXAoJQI=; b=jmDJmDgqPk6VDqvJvisA/GZbJ4ewfRerYKGACCOTennBhDMecCVQ5Ad1STpwoWxUET eAdJW3p4lmQQEg5qFDscRF1HgFV5O6umrQS6w1zklWfpO5OtDNJWcxWiAlld7UGSBW7t f+gJStYVCS6J4ju8jQwJvJ59zoXuE9qkcYLIs= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:references:from:content-type:x-mailer:message-id:date:to :content-transfer-encoding:mime-version; b=WRVAr5l2mT0HMwdAesVU0xbRyH5irgOc1GjGFcV2x2yMUaZkxoGoHvgExG4BOYyFMM VYWzunGuvda7eEnBYOOA3sv43Om/QA092YW/0F2h6uPffKnb9WjDQwmVOqq+UFqhykCa gDF4mI9Rjq4Rsn1L8CSt44+uxjEZz7WDZVZfk= Received: by 10.68.35.74 with SMTP id f10mr852729pbj.180.1308798239536; Wed, 22 Jun 2011 20:03:59 -0700 (PDT) Received: from [192.168.1.45] (c-24-23-175-32.hsd1.ca.comcast.net [24.23.175.32]) by mx.google.com with ESMTPS id g2sm883645pbh.63.2011.06.22.20.03.58 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 22 Jun 2011 20:03:58 -0700 (PDT) Subject: Fwd: How to load a sequence file with decimal data to hive ? References: From: Mapred Learn Content-Type: multipart/alternative; boundary=Apple-Mail-3--221444582 X-Mailer: iPhone Mail (8F190) Message-Id: <52C3E133-794A-4C2A-B759-FA116590BBCB@gmail.com> Date: Wed, 22 Jun 2011 20:03:54 -0700 To: mapreduce-user@hadoop.apache.org, cdh-user@cloudera.org Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (iPhone Mail 8F190) --Apple-Mail-3--221444582 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii In case anybody has some inputs : Sent from my iPhone Begin forwarded message: > From: Mapred Learn > Date: June 22, 2011 6:21:03 PM PDT > To: "user@hive.apache.org" > Subject: How to load a sequence file with decimal data to hive ? >=20 > Hi, > I have a sequence file where I have delimited data and some data is decima= l fields. > For eg: decimal(16,6). Sample value : 123.456735. > How do I upload such a sequence file and what shud I give in table definit= ion for decimal values as above ? >=20 > Thanks in advance ! >=20 > Sent from my iPhone --Apple-Mail-3--221444582 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8

In case anybody has some inputs :

Sent from my iPhone

Begin forwarded message:
<= br>
From: Mapred Learn <mapred.learn@gmail.com>
Dat= e: June 22, 2011 6:21:03 PM PDT
To: "user@hive.apache.org" <user@hive.apache.org>
Subject: How to load a se= quence file with decimal data to hive ?

<= /div>
Hi,
I have a seque= nce file where I have delimited data and some data is decimal fields.=
For eg: decimal(16,6). Sample value : 123.456735.
= How do I upload such a sequence file and what shud I give in table definitio= n for decimal values as above ?

Thanks in a= dvance !

Sent from my iPhone
= --Apple-Mail-3--221444582--