Exception in thread "main" java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 127 from org.apache.hadoop.hive.ql.exec.mr.MapredLocalTask at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:296) at hivedemo.HiveJDBCClient.makeJoinInHive(HiveJDBCClient.java:67) at hivedemo.HiveJDBCClient.main(HiveJDBCClient.java:47)
I omitted the part where I initialize connection and launch the method above because there are no problems with connection and simple one-table-select queries are completed successfully.
This error indicates that it failed to spawn a child process to do the mapjoin (MapredLocalTask).
These can be a little hard to debug, make sure you dont have any settings that would cause the child process to not be able to spawn as it picks up the variables from the parent. For example, if you have any java flags for remote debugging, etc.