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

Switch to Plain View
Pig, mail # user - Removing Paranthesis to store to DB


+
John Meek 2013-05-29, 20:50
+
Praveen Bysani 2013-05-30, 03:29
Copy link to this message
-
Re: Removing Paranthesis to store to DB
John Meek 2013-05-30, 20:31
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