Metricbeat + SQL module

112 views Asked by At

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.

1

There are 1 answers

2
imotov On BEST ANSWER

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.