For decimal, your only options in current Hive are STRING and FLOAT/DOUBLE. Or *INT if you remove the decimal point.
From: Mapred Learn [mailto:mapred.le...@gmail.com] Sent: Monday, June 27, 2011 12:13 PM To: u...@hive.apache.org; mapreduce-user@hadoop.apache.org; cdh-u...@cloudera.org Subject: Re: Resend -> how to load sequence file with decimal data 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 dcimal field. How do I specify it in the create command ? On Fri, Jun 24, 2011 at 5:12 PM, Steven Wong <sw...@netflix.com<mailto:sw...@netflix.com>> wrote: Not sure if this is what you're asking for: Hive has a LOAD DATA command. There is no decimal data type. From: Mapred Learn [mailto:mapred.le...@gmail.com<mailto:mapred.le...@gmail.com>] Sent: Thursday, June 23, 2011 7:25 AM To: u...@hive.apache.org<mailto:u...@hive.apache.org>; mapreduce-user@hadoop.apache.org<mailto:mapreduce-user@hadoop.apache.org>; cdh-u...@cloudera.org<mailto:cdh-u...@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 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
