Thanks Miao and Savant for your responses.
My file is already in HDFS but still I'm facing the error. Infact I
could browse to this file with the same path and see it's contents using
the web interface of HDFS. So I don't think it's issue with path.
Did some trial and error and now it is work
When creating external table with location clause, you need to put
your csv into HDFS.
Or else you can load data local as Savant said.
On Fri, Sep 28, 2012 at 1:57 PM, Sarath
wrote:
> Hi,
>
> I have created a new table using reference to a file on HDFS -
> create external table table1 (field1 STR
Sent: Friday, September 28, 2012 11:28 AM
To: user@hive.apache.org
Subject: Problem loading a CSV file
Hi,
I have created a new table using reference to a file on HDFS -
create external table table1 (field1 STRING, field2 STRING, field3 STRING,
field3 STRING, field4 STRING, field5 FLOAT, field6
Hi,
I have created a new table using reference to a file on HDFS -
/create external table table1 (field1 STRING, field2 STRING, field3
STRING, field3 STRING, field4 STRING, field5 FLOAT, field6 FLOAT, field7
FLOAT, field8 STRING, field9 STRING) row format delimited fields
terminated by ',' loc
