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

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


Copy link to this message
-
Removing Paranthesis to store to DB
John Meek 2013-05-29, 20:50
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