How to avoid using register pig-vertica.jar in Pig scripts?

Moderator: NorbertKrupa

Post Reply
Posts: 1
Joined: Tue Apr 10, 2012 8:18 pm

How to avoid using register pig-vertica.jar in Pig scripts?

Post by jeyendran » Tue Apr 10, 2012 8:26 pm

I installed all the Vertica jars for Hadoop and Pig (hadoop-vertica.jar, pig-vertica.jar and
vertica_4.1.17_jdk_5.jar) on all the nodes (masters and slaves) in my Hadoop cluster at $HADOOP_HOME/lib and at $PIG_HOME/lib, and then restarted my Hadoop cluster (both HDFS and MapReduce).

But I am not able to connect to Vertica using my Pig script, unless I include the following two register statements
register /usr/lib/pig/lib/pig-vertica.jar;
register /usr/lib/pig/lib/vertica_4.1.17_jdk_5.jar;
in my Pig script.

Without these register statements, Pig throws the following exception:
org.apache.pig.backend.executionengine.ExecException: ERROR 1070: Could not resolve com.vertica.pig.VerticaLoader using imports: [, org.apache.pig.builtin., org.apache.pig.impl.builtin.]

Is there a way to avoid inserting these register statements in the Pig scripts?
Is there anything else I need to do for installing Vertica Pig connectors correctly on the cluster?

The Vertica jars are from on the Vertica site.
The Hadoop cluster is running CDH3u3.

Would appreciate any help.

Thanks a lot,

User avatar
Posts: 118
Joined: Sat Apr 28, 2012 11:37 am

Re: How to avoid using register pig-vertica.jar in Pig scrip

Post by becky » Sun May 06, 2012 8:58 am

Myabe your question is too complicated, heh heh.

Post Reply

Return to “Hadoop Connector”