Splunk Search

dbx date parameters for apache drill in splunk

priyanka0309
New Member

I am trying to use apache drill to query mapr data via splunk.

Using a dbx to use the name

|dbxquery connection="Drill_" query="select count(a) as a, cast(TIME as date) as day
from table where time >= ? AND time <= ?

group by cast(TIME as date) " [|makeresults | addinfo | eval et=round(info_min_time, 0) | eval lt=if(info_max_time='+Infinity', 'now', round(info_max_time, 0)) | eval et=strftime(et,"%F")|eval lt=strftime(lt,"%F %T.%1N") | eval params=et.",".lt | fields params | format "" "" "" "" "" ""]

I get the error java.sql.SQLException: [MapR]JDBC Invalid parameter index: 1.

Looking for help

Tags (1)
0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...