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 2B2834076 for ; Mon, 27 Jun 2011 19:13:46 +0000 (UTC) Received: (qmail 81680 invoked by uid 500); 27 Jun 2011 19:13:45 -0000 Delivered-To: apmail-hadoop-mapreduce-user-archive@hadoop.apache.org Received: (qmail 81501 invoked by uid 500); 27 Jun 2011 19:13:44 -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 81493 invoked by uid 99); 27 Jun 2011 19:13:44 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Jun 2011 19:13:44 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=FREEMAIL_FROM,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,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; Mon, 27 Jun 2011 19:13:39 +0000 Received: by pzk10 with SMTP id 10so4114487pzk.35 for ; Mon, 27 Jun 2011 12:13:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=vf5WbsDOehZ8LPv249MdwvH75YV6RchGzS79HxDkxyk=; b=SDdEDFHbMpbb04A8WCNX7f0Pf0JxNNDdTjv7oprwm3u6H38aAVbY8a2DVB8byQFTv7 KE5sku3qdMfjvOgfxzm8Edx4CDumsy47PsYH/JS9ichbz+pyySHL3jGX+7xqN41LTW5k Dzjy5z8N3XsMsN8WS9uOa8GYcQBKavEi+95PU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=c3iQYHfz4Fh1IlLdiJsMdA42KlNAJXyDh/YiY2xY+Ym8IvzzS/eHxzrtCixBRm7Vz5 L4ZwlnZVf1/wSP9mIA5xzb7aPHGDZ05LEsvm0km9bjjPvz47IifLLu96+6qRf2I/KqXW kW/2YOHmUtdBR8jYkWj+6sWnnDaaX9NMrDFEM= MIME-Version: 1.0 Received: by 10.142.245.16 with SMTP id s16mr1295194wfh.139.1309201998794; Mon, 27 Jun 2011 12:13:18 -0700 (PDT) Received: by 10.142.150.25 with HTTP; Mon, 27 Jun 2011 12:13:18 -0700 (PDT) In-Reply-To: <4F6B25AFFFCAFE44B6259A412D5F9B1033183393@ExchMBX104.netflix.com> References: <4F6B25AFFFCAFE44B6259A412D5F9B1033183393@ExchMBX104.netflix.com> Date: Mon, 27 Jun 2011 12:13:18 -0700 Message-ID: Subject: Re: Resend -> how to load sequence file with decimal data From: Mapred Learn To: user@hive.apache.org, mapreduce-user@hadoop.apache.org, cdh-user@cloudera.org Content-Type: multipart/alternative; boundary=000e0cd2def213cf3004a6b65897 --000e0cd2def213cf3004a6b65897 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Hi Steven, With load data you give some info about data also. As in Tom' White's book: create external table external_table(dummy string) location.... load data.... Now dummy string is a field in this data. Similarly, what I have is a dcima= l field. How do I specify it in the create command ? On Fri, Jun 24, 2011 at 5:12 PM, Steven Wong wrote: > Not sure if this is what you=92re asking for: Hive has a LOAD DATA comma= nd. > There is no decimal data type.**** > > ** ** > > ** ** > > *From:* Mapred Learn [mailto:mapred.learn@gmail.com] > *Sent:* Thursday, June 23, 2011 7:25 AM > *To:* user@hive.apache.org; mapreduce-user@hadoop.apache.org; > cdh-user@cloudera.org > *Subject:* Resend -> how to load sequence file with decimal data **** > > ** ** > > ** ** > > Hi, > I have a sequence file where The value is text with delimited data and so= me > fields are decimal fields. > For eg: decimal(16,6). Sample value : 123.456735. > How do I upload such a sequence file in hive and what shud I give in tabl= e > definition for decimal values as above ? > > Thanks in advance !**** > > > Sent from my iPhone**** > --000e0cd2def213cf3004a6b65897 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: quoted-printable
Hi Steven,
With load data you give some info about data also. As in Tom' Whit= e's book:
create external table external_table(dummy string)
location....
load data....
=A0
Now dummy string is a field in this data. Similarly, what I have is a = dcimal field. How do I specify it in the create command ?


=A0
On Fri, Jun 24, 2011 at 5:12 PM, Steven Wong <swong@netflix.com> wrote:

Not = sure if this is what you=92re asking for: Hive has a LOAD DATA command. The= re is no decimal data type.

<= /u>=A0

<= /u>=A0

From:<= span style=3D"FONT-SIZE: 10pt"> Mapred Learn [mailto:mapred.learn@gmail.com]
Se= nt: Thursday, June 23, 2011 7:25 AM
To: user@h= ive.apache.org; mapreduce-user@hadoop.apache.org; cdh-user@cloudera.org
Subject: Resend -> how to load sequence file with decimal data

=A0

=A0

Hi,
I have a sequence file where The value is text with de= limited data and some fields are decimal fields.
For eg: decimal(16,6). = Sample value : 123.456735.
How do I upload such a sequence file in hive and what shud I give in table = definition for decimal values as above ?

Thanks in advance !<= u>


Sent from my iPhone


--000e0cd2def213cf3004a6b65897--