Community Articles

Find and share helpful community-sourced technical articles.
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.


When I run the below code on Pig View (HDP 2.5.3 and Ambari 2.4.2) in Kerberos enabled

REGISTER  '/usr/hdp/current/hive-webhcat/share/hcatalog/hive-hcatalog-pig-adapter.jar';
a = LOAD '' USING org.apache.hive.hcatalog.pig.HCatLoader();
dump a;

I get the following errors

- PIG log


07 Mar 2017 12:22:32,971 ERROR [ambari-client-thread-28] [PIG 1.0.0 Pig] JobService:232 - Exception occurred : File /user/<userID>/pig/jobs/pighivetest_07-03-2017-12-22-15/stderr not found.


Caused by: org.apache.hadoop.ipc.RemoteException( File /user/<userID>/pig/jobs/pighivetest_07-03-2017-12-22-15/stderr not found.

- Application log


2017-03-07 12:22:45,223 [main] ERROR org.apache.thrift.transport.TSaslTransport - SASL negotiation failure GSS initiate failed [Caused by GSSException: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)]

Caused by: GSSException: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)

Caused by: MetaException(message:Could not connect to meta store using any of the URIs provided. Most recent failure: org.apache.thrift.transport.TTransportException: GSS initiate failed

2017-03-07 12:24:45,466 [main] ERROR - ERROR 2245: Cannot get schema from loadFunc org.apache.hive.hcatalog.pig.HCatLoader
Details at logfile: /hadoop/1/hadoop/yarn/local/usercache/<userID>/appcache/application_1488824278698_2495/container_e187_1488824278698_2495_01_000002/pig_1488889361907.log

Interestingly, the same job runs perfectly fine while running from pig command line.


In Pig View, under the script section, there is Arguments one to add pig properties. To fix the problem, add "-useHCatalog" like presented below.


0 Kudos
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.
Version history
Last update:
‎08-17-2019 01:49 PM
Updated by:
Top Kudoed Authors