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!

Splunk Observability Cloud | Customer Survey!

If you use Splunk Observability Cloud, we invite you to share your valuable insights with us through a brief ...

Happy CX Day, Splunk Community!

Happy CX Day, Splunk Community! CX stands for Customer Experience, and today, October 3rd, is CX Day — a ...

.conf23 | Get Your Cybersecurity Defense Analyst Certification in Vegas

We’re excited to announce a new Splunk certification exam being released at .conf23! If you’re going to Las ...