Unable to read text in object

Plugins SQL
1

It is most likely me missing something, but I have trouble accessing simple key/value pair using the SQL engine, I am making simple query:

SELECT name.usual FROM customer;

The JSON return value is fine:

{
    "hits": {
        "total": {
            "value": 2,
            "relation": "eq"
        },
        "max_score": 1,
        "hits": [
            {
                "_index": "customer",
                "_id": "d1c4d98173615caf8ff5fbcdf817ff4d",
                "_score": 1,
                "_source": {
                    "name.usual": "DELL"
                }
            },
            {
                "_index": "customer",
                "_id": "769850e1b2ff5d30b0ae75638fcb6d03",
                "_score": 1,
                "_source": {
                    "name.usual": "HP"
                }
            }
        ]
    }
}

But the query returns NULL values when using the Query Workbench or the JDBC driver.

Can someone help me out?

2

Hi, could you try

SELECT `name.usual` FROM customer;

If it still doesn’t work, could you provide your index mapping?