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> 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] > *Sent:* Thursday, June 23, 2011 7:25 AM > *To:* u...@hive.apache.org; mapreduce-user@hadoop.apache.org; > 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**** >
