The error messages in Hue, were not really helpful..they seem to always be Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code  regardless of the underlying sqoop problem. Had to track the errors down to HDFS /tmp/logs/cloudera/logs (cloudera is the user), all the UIs just show the Exit 1 error.
1. JDBC Drivers need to be in Oozie shared lib. They aren't there by default. We should make sure the ones we ship get put there so that the customer doesn't have to do it.
2. If you do a hive import you have to reference the hive-site.xml file...which means you have to get it off the local filesystem, upload it somewhere in HDFS, then add a file parameter to the Oozie workflow.