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
Hi Sarath,
Considering your two step approach...
The load command by default searches for file in HDFS, so you are doing the
same by following command
hive> load data inpath '/user/hduser/dumps/table_dump.csv' overwrite into table
table1;
instead, you can use 'local' to tell hive that the CSV
