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

Copy link to this message
Removing Paranthesis to store to DB

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.
Praveen Bysani 2013-05-30, 03:29
John Meek 2013-05-30, 20:31