I am currently starting with Talend and I am facing a problem.
I use DBVisualizer as database tool and I have no error on it. Then I try the same query into Talend. When I use the 'Guess Schema' button, I face the following error :
Invalid escape sequence (valid ones are \b \t \n \f \\" \' \\)
From what I understand, the problem is in the syntax of my query. I should escape "\" with "\\". Then, the point I don't understand is that I have no "\" into my query and still this error.
You will find in attachment the query I use.
If someone can explain to me the origin of the problem, I would be grateful.
Thank you in advance,