So you are using a java program to execute a "load data infile"
command on mysql through JDBC?
If so I *think* you would have to copy it onto the mysql machine from
HDFS first, or the machine running the command and then try a 'load
data local infile'.

Or pehaps use the
http://hadoop.apache.org/core/docs/current/api/org/apache/hadoop/mapred/lib/db/DBOutputFormat.html

Cheers

Tim

On Tue, May 19, 2009 at 9:54 PM, dealmaker <vin...@gmail.com> wrote:
>
> Hi,
>  I am want to load data in mysql using a hadoop file similar to following:
> LOAD DATA INFILE 'test.txt' INTO TABLE test
>  FIELDS TERMINATED BY ','  LINES STARTING BY 'xxx';
>
> But how do I load the hdfs file into the mysql comand above?  Do I start the
> file name with hdfd://test.txt?  I am using java.
> Thanks.
>
> --
> View this message in context: 
> http://www.nabble.com/Mysql-Load-Data-Infile-with-Hadoop--tp23623256p23623256.html
> Sent from the Hadoop core-user mailing list archive at Nabble.com.
>
>

Reply via email to