Hi,
We can set Hive Action configuration using the property oozie.hive.log.level and the default value will be Zero for this.
You can change it to DEBUG and include in your Hive Action configuration of your workflow.xml.
<configuration>
<property>
<name>oozie.log.hive.level</name>
<value>DEBUG</value>
</property>
</configuration>
I hope it will work.