Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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]>
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

 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB