title: Increase Heap size for hive query
body: <p>I recently started working on Hive by using on Unix interface or on SQL workbench.<br>
  Sometimes I am facing an error that says "Please increase your Java heap space using Xmx parameter". I think this relates to efficiency of the query. Can anyone give me some context on Heap size and help me increase this ?</p>