[BACKLOG-365] Unable to create a database table data source against Apache Hadoop

Handle case with old shims not having hive2 driver.
Detect pentaho's hive and hive2 error messages in setAutoCommit.