I'm trying to put multiline sql search (as our source-code are long and in multile lines), but even if I put escape characters, error happens. Please find screenshot
"type" : "json_parse_exception", "reason" : "Illegal unquoted character ((CTRL-CHAR, code 10)): has to be escaped using backslash to be included in string value\n at [Source: (org.elasticsearch.transport.netty4.ByteBufStreamInput); line: 2, column: 64]"
I tried putting
none of these worked.
The original SQL from code is in format of
SELECT OriginCityName, DestCityName FROM flights WHERE FlightTimeHour > 5 AND OriginCountry='US' ORDER BY FlightTimeHour DESC LIMIT 10
which I don't want to manipulate to single line.