Problem in CSV result - Rest API ?

[githubmui]

ES 5.5.2:
"flat=true" in URL results in an error 400 (bad request)
Same with "separator=;" within URL.
e.g. http://xxxx:9200/_sql?flat=true&separator=;&format=csv&sql=select field from index
Is this feature still supported or is it maybe a bug?

[shi-yuan]

http://xxxx:9200/_sql?flat=true&separator=%3B&format=csv&sql=select field from index

[yangjiajun2014]

ES 5.6.2 still has this bug?
{
"error": {
"root_cause": [
{
"type": "illegal_argument_exception",
"reason": "request [/_sql] contains unrecognized parameter: [separator]"
}
],
"type": "illegal_argument_exception",
"reason": "request [/_sql] contains unrecognized parameter: [separator]"
},
"status": 400
}

[shi-yuan]

use elasticsearch-sql version 5.6.2.1

[yangjiajun2014]

But I can not find this version on the download site.

[shi-yuan]

yeah, you should build by yourself.
👉 elasticsearch-sql-5.6.2.1.zip