I think your data probably terminated by comma character.
If is that, recreate table like the following
CREATE TABLE table_name{
.
}
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ',';
If is not, review your table describe and data samples
Zhu weimin
From: Fan Yang [mailto:[email protected]]
Sent: Tuesday, April 06, 2010 11:19 AM
To: [email protected]
Subject: Problems of loading data from hdfs
Hi
When I try to load data into table from hdfs, it seems successful and gives
no warnings. But using select clause can't get any result from the table.
However, after I load data from local file which is download from hdfs by
using 'hadoop dfs get' command, I can select out records.
Note, these two files are exactly the same and no errors were given during
the procedure.
Thanks in advance.
Fan
