question Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM in Archives of Support Questions (Read Only)

Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

Sach — Fri, 16 Sep 2022 09:05:26 GMT

Hi,

I am new to Hadoop. I am trying to run below basic statement in Pig Editor. I am using Cloudera Quickstart VM.

sample_07 = LOAD 'sample_07' USING org.apache.hcatalog.pig.HCatLoader();

However, I am getting below error while running the script. I have not added any properties at the time of run. Please help.

ErrorCode [EJ001], Message [Could not locate Oozie sharelib]

Thanks

Sach

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

Sach — Tue, 19 Aug 2014 01:59:42 GMT

Hi,

Please help on this.

Thanks

Sach

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

davidpeleg — Tue, 19 Aug 2014 11:57:25 GMT

Hi.

I had the same problem. It turns out that they have a bug in the VM, misconfigured oozie service.

What I did is:

1. Open CDH VM in VMWare Player / Workstation

2. Open system console - appears on top desktop's toolbar

3. Write the following lines:

3.1. sudo service oozie stop

3.2. sudo oozie-setup sharelib create -fs /user/oozie/share/lib/mr1 -locallib /usr/lib/oozie/oozie-sharelib-mr1.tar.gz

3.3. sudo service oozie start

Then try running Pig script again. Worked for me.

What this does is reinstalling share/lib required libraries.

See details here: http://www.cloudera.com/content/cloudera-content/cloudera-docs/CDH5/latest/CDH5-Installation-Guide/cdh5ig_oozie_configure.html

Hope it helps you too.

David.

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

Sach — Tue, 19 Aug 2014 17:32:41 GMT

Thanks a lot, David.

I am able to move forward and stuck with below error while running Pig script.

[main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 2245: Cannot get schema from loadFunc org.apache.hcatalog.pig.HCatLoader

Please advice.

Thanks

Sach

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

davidpeleg — Wed, 20 Aug 2014 08:04:45 GMT

I am not familiar with this error but Googling around leads me to this, maybe it helps: http://stackoverflow.com/questions/22304947/cannot-load-hive-table-into-pig-via-hcatalog

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

Sach — Thu, 28 Aug 2014 04:00:23 GMT

Re: Pig Editor Error- ErrorCode [EJ001], Message [Could not locate Oozie sharelib] on QuickStart VM

Sach — Thu, 28 Aug 2014 04:01:48 GMT

Hi,

After adding site_hive.xml file to pig script using properties, I am able to run pig scripts.

Thanks for all your help.

Sach