Are flattened
type fields really not usable with SQL queries? They're not mentioned in:
I have an index with these fields:
...
"mappings" : {
"properties" : {
"name" : {
"type" : "keyword",
}
"paths" : {
"type" : "flattened"
},
And a document like:
"name" : "1/2/3/4/4.txt",
"paths" : {
"p1" : "1",
"p2" : "2",
"p3" : "3",
"p4" : "4",
"p5" : "4.txt"
},
that I expected to be returned from:
{
"query": "SELECT name,\"paths.p5\" FROM \"my-index\" where name like '1/%'"
}
but Elasticsearch 7.15.1 returns this error (I do have another field named path
).
"verification_exception",
"reason": "Found 1 problem\nline 1:13: Unknown column [paths.p4], did you mean [path]?"```