How to map the result of elasticsearch SQL API request to a java POJO?

79 Views Asked by At

I am trying to send SQL queries to elasticsearch server using the SQL API ( I am using the free version so I can't use the JDBC driver they provide) and I was wondering how I can map the result of the query since it comes back like this:

{
    "columns": [
        {
            "name": "project_id",
            "type": "text"
        }
    ],
    "rows": [
        [
            "item1"
        ],
        [
            "item2"
        ],
        [
            "item3"
        ],
        [
            "item4"
        ],
        [
            "item5"
        ],
        [
            "item6"
        ]
    ]
}'''
0

There are 0 best solutions below