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 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