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

[benjaminlin1019]

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?

[benjaminlin1019]

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