All Apps and Add-ons

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


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 :

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!

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

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

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 2 releases of new security content via the ...

Announcing the 1st Round Champion’s Tribute Winners of the Great Resilience Quest

We are happy to announce the 20 lucky questers who are selected to be the first round of Champion's Tribute ...

We’ve Got Education Validation!

Are you feeling it? All the career-boosting benefits of up-skilling with Splunk? It’s not just a feeling, it's ...