[jira] [Created] (HIVE-5092) Fix hiveserver2 mapreduce local job on Windows

["Daniel Dai (JIRA)" <ji...@apache.org>]

Daniel Dai created HIVE-5092:
--------------------------------

             Summary: Fix hiveserver2 mapreduce local job on Windows
                 Key: HIVE-5092
                 URL: https://issues.apache.org/jira/browse/HIVE-5092
             Project: Hive
          Issue Type: Bug
          Components: HiveServer2, Windows
            Reporter: Daniel Dai
            Assignee: Daniel Dai
             Fix For: 0.12.0


Hiveserver2 fail on Mapreduce local job fail. For example:
{code}
select /*+ MAPJOIN(v) */ registration from studenttab10k s join votertab10k v on (s.name = v.name);
{code}

The root cause is "class not found" in the local hadoop job (MapredLocalTask.execute). HADOOP_CLASSPATH does not include $HIVE_HOME/lib. Set HADOOP_CLASSPATH correctly will fix the issue.

However, there is one complexity in Windows. We start Hiveserver2 using Windows service console (services.msc), which takes hiveserver2.xml generated by hive.cmd. There is no way to pass environment variable in hiveserver2.xml (weird but reality). I attach a patch which pass it through command line arguments and relay to HADOOP_CLASSPATH in Hive code. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira