Hello All,                  I am using the row table expansion.js from dashboard examples. But I can only do 1 one level row expansion but I actually wanted a two-level row expansion. I am not good with Javascript so just wanted to get it the two level nesting.              ... View more

Hello All,                   I have a table view where I need to add the custom cell expansion with + button before the value   If I click on the Add button before the cell values, I need to get the expansion of all the associated values.  Main search = index= _internal | stats values(sourcetype) by host cell expansion = index=_internal | search cellclickvalue | stats values(Source) by cellclickvalue   ... View more

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. Splunk HF version 8.0 Splunk App_for Db connect 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 ... View more

Hello, We have Hortonworks Hive 3.1 and when we are trying to query the connection from Splunk DB connect to HortonWorks Hive. I see the SQL method error. But we are using the same Drivers that our internal apps are using. ... View more

| inputlookup Roster.csv Level 1 Manager Level 2 Manager Level 3 Manager Ganesh Ganesh Ganesh The result should be like this Level 1 Manager Level 2 Manager Level 3 Manager N/A N/A Ganesh Like this i have 13,000 rows.. So i need to work on this to make sure that for every row, the matching results should be eliminated and the value is to be in the final row and the remaining values should be N/A. ... View more