note: solutions for resolving "Execution failed with exit status: 3" error while using "hive.auto.convert.join=true" setting.
1. use "hive.auto.convert.join=false" or
2. reduce "hive.smalltable.filesize" or
3. increase maximum size for the Java process heap memory which will be passed to Java -Xmx. (If you happen to use cloudera manger, then it will be at 'hive -> configuration -> gateway default group -> resource management -> client java heap size in bytes')
I suggest to use option 3, if it is possible for your specific use case.
