# Unable to read text in object

**URL:** <https://forum.opensearch.org/t/unable-to-read-text-in-object/11830>\
**Category:** SQL\
**Created:** [December 15, 2022, 5:57pm UTC](https://forum.opensearch.org/t/unable-to-read-text-in-object/11830 "2022-12-15T17:57:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yoshi](https://avatars.discourse-cdn.com/v4/letter/y/aeb1de/32.png) [@Yoshi](https://forum.opensearch.org/u/Yoshi)\
**Post date:** [December 15, 2022, 5:57pm UTC](https://forum.opensearch.org/t/unable-to-read-text-in-object/11830/1 "2022-12-15T17:57:45Z")

</div>

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:

```auto
SELECT name.usual FROM customer;

```

The JSON return value is fine:

```auto
{
    "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?

---

<div class="post-metadata">

**Author:** ![joshli](https://avatars.discourse-cdn.com/v4/letter/j/a9a28c/32.png) [@joshli](https://forum.opensearch.org/u/joshli)\
**Post date:** [March 13, 2023, 6:31pm UTC](https://forum.opensearch.org/t/unable-to-read-text-in-object/11830/2 "2023-03-13T18:31:13Z")

</div>

Hi, could you try

```auto
SELECT `name.usual` FROM customer;

```

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