Can SQL support more nested object level

Plugins SQL
1

Hi, as my testing, current SQL support 1 level object, for example, I have data saved in elasticsearch like this. Is this a bug or by design? can the be fixed and support more level.
{timestamp: “xxxxxxx”,
“report”: {
“generatedUsing”: “client_and_server”,
“intervalMetadata”: {
“localIP”: “10.10.10.240”
}
}
the following SQL works,
POST _opendistro/_sql?format=jdbc
{
“query”: “select timestamp , report.generatedUsing from indexname”
}
but not when it is
POST _opendistro/_sql?format=jdbc
{
“query”: “select timestamp , report.intervalMetadata.localIP from indexname”
}

2

Hi @jockjiang, we tried to fix this in this PR (Lack of support for nested documents with more than one level of nesting · Issue #152 · opendistro-for-elasticsearch/sql · GitHub) but discarded due to complexity in old code. We are refactoring our codebase and will consider supporting this in future. Thanks!

3

Thanks @daichen for your update.