# Keyword with lowercase , text with raw case content

**URL:** <https://discuss.elastic.co/t/keyword-with-lowercase-text-with-raw-case-content/370643>\
**Category:** Elasticsearch\
**Created:** [November 16, 2024, 2:57pm UTC](https://discuss.elastic.co/t/keyword-with-lowercase-text-with-raw-case-content/370643 "2024-11-16T14:57:55Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rz2024](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rz2024/32/138173_2.png) [@Rz2024](https://discuss.elastic.co/u/Rz2024)\
**Post date:** [November 16, 2024, 2:57pm UTC](https://discuss.elastic.co/t/keyword-with-lowercase-text-with-raw-case-content/370643/1 "2024-11-16T14:57:55Z")

</div>

the text field publisher the mapping and the index setting for books

```auto
"publisher": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256,
              "normalizer": "lowercase_normalizer"
            }
          },
          "analyzer": "lowercase_analyzer"
        },  

and index setting:

 "analysis": {
          "normalizer": {
            "lowercase_normalizer": {
              "filter": [
                "lowercase"
              ],
              "type": "custom"
            }
          },
          "analyzer": {
            "lowercase_analyzer": {
              "filter": [
                "lowercase"
              ],
              "type": "custom",
              "tokenizer": "standard"
            }
          },

```

How can I make an Elasticsearch `_sql` call to return the raw (original case) text value instead of the lowercase value stored in the `keyword` subfield in my `GROUP BY` query? For example: select publisher, count(_) from books group by publisher; or select left(publisher,10), count(_) from books group by left(publisher,10);