Oozie also has Hive 2 action, where we can use Hive Server 2 and execute our Hive queries. Hive 2 action uses Beeline to execute queries via the Hive Server 2.
Here's the general command to talk to the Beeline server:
beeline> !connect jdbc:hive2://localhost:10000 username password org.apache.hive.jdbc.HiveDriver
Tip
To know more about how Beeline and Hive Server 2 work, check out the Cloudera website blog post at http://blog.cloudera.com/blog/2014/02/migrating-from-hive-cli-to-beeline-a-primer/.
The general schema for Hive action is as follows:
<action> <job-tracker> // Job tracker details <name-node> // Name node details <prepare> // Create or Delete directory <job-xml> // Any job xml properties <configuration> // Hadoop job configuration <jdbc-url> // HiveServer2 JDBC URL <password> // Password (if any for Hiveserver2) <script> ...