1

I'm trying to output a pig script with 3 fields to a PostgreSQL database. When I dump the output, the script works fine. However when I use the DBStorage() method:

register /$directory/postgresql9.4-1201.jdbc41.jar;
register /usr/lib/pig/piggybank.jar;
(removed for privacy purposes)
order_product = order count_product by post_product_list, datew;

store order_product into '$dbschema.$dbtable'
    using org.apache.pig.piggybank.storage.DBStorage('org.postgresql.Driver',
    'jdbc:postgresql://$server:$port/$database',
    '$user',
    '$pass',
    'insert into $dbschema.$dbtable values (?,?,?)');

When I run the above script, I recieve this error:

pig script failed to validate: java.lang.RuntimeException: could not  instantiate 'org.apache.pig.piggybank.storage.DBStorage' with arguments '[org.postgresql.Driver...

I've checked my syntax in DbStorage multiple times and it looks fine. Could anyone offer a word or two?

Thanks!

zaralleru
  • 11
  • 2

0 Answers0