Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig >> mail # user >> Removing Paranthesis to store to DB

Copy link to this message
Re: Removing Paranthesis to store to DB
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]>
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://
>','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

Praveen Bysani