Writing hive Query output to a HDFS file
<p>I have tested writing hive query output to a file  by executing hive queries inside shell script  using hive –e and hive –f options. when i tried  executing the shell script from putty it is working fine, however in the hue box from oozie workflow the same shell script is not writing any results to local file.</p>

<ol start="2">
<li>Using Insert overwrite directory I can directly write hive query output to a directory inside HDFS however for each query it creates a new directory so I can not use this option.</li>
</ol>

<p>Please suggest me any alternative option to write multiple hive query output to a single file by executing shell script from oozie workflow.</p>

<p>Thanks in advance.</p>