HI Praveen,
Thanks for reply. I was able to get rid of the error by Doing a Group and then
Flattening the group and then storing using PigStorage(',').
.
-----Original Message-----
From: Praveen Bysani <[email protected]>
To: user <[email protected]>
Sent: Thu, May 30, 2013 12:56 pm
Subject: Re: Removing Paranthesis to store to DB
Hi John,
What is the exception you are facing ?
On 30 May 2013 04:50, John Meek <[email protected]> wrote:
> All,
>
> How do I remove the paranthesis in my output?
>
> I have a statement like -
>
> STORE Output INTO 'table' USING
> org.apache.pig.piggybank.storage.DBStorage('com.mysql.jdbc.Driver','jdbc:mysql://
> 172.45.50.40:7312/db','user','pwd','INSERT INTOdata (name, operation,
> date, val, source, target) VALUES (?,?,?,?,?,?)');
>
>
> RDBMS does not know how to process my data which is in form of
> (name,operation,date,value,source,target)
>
> I tried the flatten operator but no effect.
>
>
> thanks,
> JM
>
--
Regards,
Praveen Bysani
http://www.praveenbysani.com
