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 Plain View
Pig >> mail # user >> Removing Paranthesis to store to DB


+
John Meek 2013-05-29, 20:50
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
+
John Meek 2013-05-30, 20:31
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