we were facing issues with hive running local mapred task, and we fixed that here, https://github.com/caskdata/cdap/pull/3270.
we add hive-exec.jar to the explore classpath for running local mapreduce task.
to get the hive-exec.jar
this was tested in cdh-5.3 and works, however in cdh-5.4 the same statement gives hive-jdbc-1.1.0-cdh5.4.4-standalone.jar instead of hive-exec.jar
we have to understand why and get hive-exec.jar instead in the classpath, that should fix the issue.