All Apps and Add-ons

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

iamkilarunaresh
Explorer

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

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...