SQL query failed due to multi-nested

Elastic Stack Elasticsearch
1

I am trying to index the following document and I have made results a nested type.

 {
      "template_version": "B",
      "study": {
        "source": "A"
      },
      "results": [
        {
          "barcode": "S",
          "assay": {
            "type": "B",
            "sub_type": "H"
          },
          "value": 0.98,
          "unit": "nM",
          "image": "1d6",
          "metric": "IC50"
        },
        {
          "barcode": "S",
          "assay": {
            "type": "B",
            "sub_type": "LC"
          },
          "value": 2.3,
          "unit": "nM",
          "image": "1dac",
          "metric": "IC50"
        }
     ]
    }

When I run the SQL query SELECT *, results.*, results.assay.* FROM index, I got the following error

sql_illegal_argument_exception
Multi-nested docs not yet supported [results, results.assay]

Is this a known issue? If so, when/if will this be solved? Is it possible to run SELECT * FROM index to get all the fields/properties, independent how nested they are, back?

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.