I will try later in the day to test against CDH, maybe they have a different setup then the vanilla Hive (I've tested against the official
vanilla Hive 0.8,0.9 and 0.10) - what version are you using?
the CNF might be more then a red herring - typically if a CNF is raised, the job won't fail right away but rather after it times out. This looks like your case as well. Can you enable more logging for Hive (note you have to do this inside your app) and also check the Hadoop jobs just in case ?