I Found the jar file was in this directory:   [cloudera@quickstart lib]$ find ./ -name hive-contrib.jar ./hive/lib/hive-contrib.jar ./oozie/oozie-sharelib-mr1/lib/hive/hive-contrib.jar ./oozie/oozie-sharelib-yarn/lib/hive/hive-contrib.jar   [cloudera@quickstart lib]$ pwd /usr/lib/hive/lib [cloudera@quickstart lib]$ ls -ltr hive-contrib.jar lrwxrwxrwx 1 root root 32 Oct 23 09:59 hive-contrib.jar -> hive-contrib-1.1.0-cdh5.13.0.jar [cloudera@quickstart lib]$   then used the same  ADD JAR /usr/lib/hive/lib/hive-contrib.jar   and it worked. ... View more

This is pretty well laided out in the documantion...need to stop and read though it though. Now you can build a table in Hive and query the data via Impala and Hue. You'll build this table in 2 steps. First, you'll take advantage of Hive's flexible SerDes (serializers / deserializers) to parse the logs into individual fields using a regular expression. Second, you'll transfer the data from this intermediate table to one that does not require any special SerDe. Once the data is in this table, you can query it much faster and more interactively using Impala. We'll use the Hive Query Editor app in Hue to execute the following queries: ) ... View more