Splunk > HortonWorks Hive connection not working with Splunk app for DB connect

[iamkilarunaresh]

Hello All,

I am trying to set up the connection for HortonWorks using Splunk App for DB connect but getting the "SQL Method not supported" errors while trying to query the hive tables.

1. Splunk HF version 8.0
2. Splunk App_for Db connect 3
3. HortonWorks hive 3.1

Drivers installed :
hive-jdbc-3.1.0.3.1.0.179-1-standalone.jar
hadoop-common-3.1.1.3.1.0.179-1.jar
hadoop-auth-3.1.1.3.1.0.179-1.jar

I was able to make the connection and can see all the schemas and tables but when I select the table I am getting the "SQL Method not supported" error. Please assist!

[Hive-Connection]
displayName=hive-hortonworks
serviceClass=com.splunk.dbx2.DefaultDBX2JDBC
jdbcUrlFormat = jdbc:hive2://:/
jdbcUrlSSLFormat = jdbc:hive2://:/

jdbcDriverClass = com.cloudera.hive.jdbc41.HS2Driver

jdbcDriverClass = org.apache.hive.jdbc.HiveDriver

jdbcDriverClass = org.apache.hadoop.hive.cli.CliDriver

port = 10000

[Hive__mte]
connection_type = Hive-Connection
customizedJdbcUrl = jdbc:hive2://xxxxxxxxxxx:10000/
disabled = 0
enable_query_wrapping = false
host = xxxxx
database =
identity = splnkdb2
jdbcUseSSL = false
port = 10000
readonly = false