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 5668249EA for ; Thu, 23 Jun 2011 14:25:53 +0000 (UTC) Received: (qmail 38268 invoked by uid 500); 23 Jun 2011 14:25:52 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 38216 invoked by uid 500); 23 Jun 2011 14:25:52 -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 38208 invoked by uid 99); 23 Jun 2011 14:25:52 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Jun 2011 14:25:52 +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 (nike.apache.org: domain of mapred.learn@gmail.com designates 74.125.83.176 as permitted sender) Received: from [74.125.83.176] (HELO mail-pv0-f176.google.com) (74.125.83.176) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 23 Jun 2011 14:25:43 +0000 Received: by pve37 with SMTP id 37so1660937pve.35 for ; Thu, 23 Jun 2011 07:25:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:subject:from:content-type:x-mailer:message-id :date:to:content-transfer-encoding:mime-version; bh=5j9xmSqKBgMk36AwVyO3MmMIc8FVY1Cae3T5HT77oU0=; b=oLFRh5CvIaUByijZJpt5odnMVTp1MofLNlNxWatF+8qb854GsDiOjhE/IjxOhKQG+l WJYZHXkDS1+B6l3JVDqC7LiG79O3SBWrWrZ5ee39s5GoOIOokC1R70Dr0lH9kJh1hjR5 RH588CTl9xSZvgHgn+N/kgnIdiEjlKXxyGHqc= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=subject:from:content-type:x-mailer:message-id:date:to :content-transfer-encoding:mime-version; b=cULFRs2maEM6Oxy9oTr42DjvT6zfV4F6L/WGif5tsKTFKzb/Ssg4ZPXYm2fnunwuDA BpenZflh8jl6nzDe8ZwLlp6GAT92GcqKuIdY9w0YLgLix9XUodMSSgHrYQOjkh+neIkb xfrSlq0zu8bYsZL9CwqrnYWQPnrwkFnUEQYxo= Received: by 10.68.48.233 with SMTP id p9mr1138833pbn.275.1308839121949; Thu, 23 Jun 2011 07:25:21 -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 i9sm1264917pbk.36.2011.06.23.07.25.20 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 23 Jun 2011 07:25:21 -0700 (PDT) Subject: Resend -> how to load sequence file with decimal data From: Mapred Learn Content-Type: multipart/alternative; boundary=Apple-Mail-4--180562348 X-Mailer: iPhone Mail (8F190) Message-Id: Date: Thu, 23 Jun 2011 07:25:15 -0700 To: user@hive.apache.org, mapreduce-user@hadoop.apache.org, cdh-user@cloudera.org Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (iPhone Mail 8F190) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-4--180562348 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii > Hi, > I have a sequence file where The value is text with delimited data and som= e 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 ? >=20 > Thanks in advance ! >=20 Sent from my iPhone= --Apple-Mail-4--180562348 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=utf-8

Hi,
I have a sequence file where The value is text with delimited 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 !

Sent from my iPhone

--Apple-Mail-4--180562348--