https://community.cloudera.com/t5/Support-Questions/File-does-not-exist-Error-with-org-apache-hive-hcatalog-pig/m-p/142389#M104982 <P>The link tells you to restart all services. We had to explicitly restart the YARN services after restarting all services in order to get YARN to work, and then the execution of the Pig script would work. Note that we explicitly added the \pigscripts directory and made sure permissions were set to 777 before we restarted.</P> Tue, 09 Aug 2016 01:58:42 GMT jpollack 2016-08-09T01:58:42Z https://community.cloudera.com/t5/Support-Questions/File-does-not-exist-Error-with-org-apache-hive-hcatalog-pig/m-p/142387#M104980 <P>Pig Script in Ambari Pig View with useHCatalog tag:</P><P>a = LOAD 'batting_data' using org.apache.hive.hcatalog.pig.HCatLoader(); b = LOAD 'master_data' using org.apache.hive.hcatalog.pig.HCatLoader(); c = join a by playerid, b by playerid; dump c;</P><P>--------------</P><P>Confirmed that tables exist in default database, but get following error:</P><P></P><H4><A href="http://192.168.0.101:8080/views/PIG/1.0.0/PigView/#scriptLogs"></A></H4>File does not exist: /user/admin/pig/jobs/bb_16-02-2016-02-38-56/stdout at org.apache.hadoop.hdfs.server.namenode.INodeFile.valueOf(INodeFile.java:68) at org.apache.hadoop.hdfs.server.namenode.INodeFile.valueOf(INodeFile.java:58) at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getBlockLocationsUpdateTimes(FSNamesystem.java:1964) at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getBlockLocationsInt(FSNamesystem.java:1905) at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getBlockLocations(FSNamesystem.java:1885) at org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getBlockLocations(FSNamesystem.java:1857) at org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.getBlockLocations(NameNodeRpcServer.java:622) at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.getBlockLocations(ClientNamenodeProtocolServerSideTranslatorPB.java:364) at org.apache.hadoop.hdfs.protocol.proto.ClientNamenodeProtocolProtos$ClientNamenodeProtocol$2.callBlockingMethod(ClientNamenodeProtocolProtos.java) at org.apache.hadoop.ipc.ProtobufRpcEngine$Server$ProtoBufRpcInvoker.call(ProtobufRpcEngine.java:619) at org.apache.hadoop.ipc.RPC$Server.call(RPC.java:962) at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:2141) at org.apache.hadoop.ipc.Server$Handler$1.run(Server.java:2137) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1671) at org.apache.hadoop.ipc.Server$Handler.run(Server.java:2135) Tue, 16 Feb 2016 13:41:58 GMT https://community.cloudera.com/t5/Support-Questions/File-does-not-exist-Error-with-org-apache-hive-hcatalog-pig/m-p/142387#M104980 ojusnaik 2016-02-16T13:41:58Z https://community.cloudera.com/t5/Support-Questions/File-does-not-exist-Error-with-org-apache-hive-hcatalog-pig/m-p/142388#M104981 <P>@<A href="https://community.hortonworks.com/users/2817/ojusnaik.html">Ojustwin Naik</A></P><P>If you are using HDP 2.3 here is the solution there was a kira already resolved. <A target="_blank" href="https://issues.apache.org/jira/browse/AMBARI-12738">link</A></P><P>Let me know if that helped</P> Tue, 16 Feb 2016 13:49:06 GMT https://community.cloudera.com/t5/Support-Questions/File-does-not-exist-Error-with-org-apache-hive-hcatalog-pig/m-p/142388#M104981 Shelton 2016-02-16T13:49:06Z https://community.cloudera.com/t5/Support-Questions/File-does-not-exist-Error-with-org-apache-hive-hcatalog-pig/m-p/142389#M104982 <P>The link tells you to restart all services. We had to explicitly restart the YARN services after restarting all services in order to get YARN to work, and then the execution of the Pig script would work. Note that we explicitly added the \pigscripts directory and made sure permissions were set to 777 before we restarted.</P> Tue, 09 Aug 2016 01:58:42 GMT https://community.cloudera.com/t5/Support-Questions/File-does-not-exist-Error-with-org-apache-hive-hcatalog-pig/m-p/142389#M104982 jpollack 2016-08-09T01:58:42Z