Hi Chen, Can you double check the format of the file? Is it plain text?
CREATE TABLE IF NOT EXISTS userweight(source INT, dist INT, weight DOUBLE) ROW FORMAT delimited fields terminated by " \t" STORED AS TEXTFILE; The optional "STORED AS" clause tells Hive the format of your file. Hive supports TEXTFILE and SEQUENCEFILE natively. If your file has a customized format, you need to write your own fileformat classes. Please take a look at the example added by: https://issues.apache.org/jira/browse/HIVE-639 Zheng On Mon, Jul 20, 2009 at 3:53 PM, chen keven<[email protected]> wrote: > I'm trying to load data into table using the command below. However, I only > got a bunch of NULL in the field. The data fields are seperated by tab. > > CREATE TABLE IF NOT EXISTS userweight(source INT, dist INT, weight DOUBLE) > row format delimited fields terminated by " \t"; > load data local inpath "/tmp/Graph/edges_tag_jaccard_directed_2006.dat" into > table userweight > > -- > Thank you, > Keven Chen > -- Yours, Zheng
