Splunk Search

Splunk DB Connect: What is wrong with my SQL syntax to MySQL database that db monitor fails validation?

benjaminlin1019
Explorer

Is there anyone can tell me what's wrong with my SQL syntax to MySQL database is wrong that db monitor can't be saved.

SELECT * FROM database_name.mytext_table_name WHERE MATCH(mytext) AGAINST('some key words' IN BOOLEAN MODE) {{AND $rising_column$ > ? }}

Although I dump MySQL datetime column with these setting:
Timestamp column: textdate
format: yyyy-MM-dd HH:mm:ss

cron interval

0,5,10,15,20,25,30,35,40,45,50,55 * * * *

also why */5 * * * * doesn't work either?

0 Karma

benjaminlin1019
Explorer

Ok answer myself I know the problem is that we are using MariaDB 10 which is compatible with MySQL 5.6 and in the new version, they removed "SET OPTION" command in MySQL...gosh https://mariadb.atlassian.net/browse/MDEV-6201

but it can be resolved by using latest Java Connector however, we have trouble to use latest Java Connector

0 Karma
Get Updates on the Splunk Community!

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...

The Latest Cisco Integrations With Splunk Platform!

Join us for an exciting tech talk where we’ll explore the latest integrations in Cisco + Splunk! We’ve ...

AI Adoption Hub Launch | Curated Resources to Get Started with AI in Splunk

Hey Splunk Practitioners and AI Enthusiasts! It’s no secret (or surprise) that AI is at the forefront of ...