I am a new user to pig latin and this is the first time I am sending an
email to the mailing group. excuse me if I have made a mistake.
I have a pig latin script that cleans the raw log file and then I want to
store the cleanlog file(data) into a mySql data base
Problem
Following is the command
STORE data INTO DBStorage ('com.mysql.jdbc.Driver', 'dbc:mysql://
127.0.0.1/AnalyticsDB','Insert into test
(created_at,host_name,auth_id)values (?,?,?)');
But I am getting an error
2012-10-17 11:04:40,177 [main] ERROR org.apache.pig.tools.grunt.Grunt -
ERROR 1200: <line 23, column 14> mismatched input 'DBStorage' expecting
QUOTEDSTRING
Action
I tired to read the stack trace generated inthe log file but wasn't able to
figure out
I have searched for this error but couldn't find the answer.
I came across the sqoop tool to load data in and out of HDFS but I want to
keep it simple using DBStorage at this point.
Version
I am using pig 0.10
and mySQL 5.5.24
I would really appreciate if anyone could help me resolve this problem.
Thanks
Pankaj
