I have the SQL queries which use regexp_replace function with special character '([^,]+)(,\1)*(,|$)', '\1\3' This was not working when I start the metricbeat. I used double " for entire query still its not working.. any help is much appreciated.
I have the SQL queries which use regexp_replace function with special character '([^,]+)(,\1)*(,|$)', '\1\3' This was not working when I start the metricbeat. I used double " for entire query still its not working.. any help is much appreciated.
It is hard to answer your question without seeing full statement, but I suspect the issue is in not escaping escape character. Metricbeat is using yaml syntax that treats
\as an escape character in strings. So, try adding an extra\before each\. If that doesn't work, please post the whole configuration snippet not just the regex and the error message that you are getting.