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!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

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

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...