Convert string to integer

[ANKITA_SAHA]

Hello everyone!
I need help for converting a string data to integer value.
I have an 'Hours' column which consist of numeric data but kibana is reading as string as a result when i try to sort the axis it does not sort properly.

Can someone please tell me steps to convert string to integer?

I use Kibana 7.13.2.

[nickpeihl]

Can you share the mapping for your index, particularly the Hours field?

[ANKITA_SAHA]

"hour": {
          "type": "text",
          "fields": {
            "keyword": {
              "type": "keyword",
              "ignore_above": 256
            }
          }
        },

The problem is it is reading the heading 'hour' as a result it converts entire field to text.
I created ingest pipeline to convert str to int and reindex but unfortunately it always gives error like "type" : "number_format_exception", "reason" : "for input string: "hour""

[ANKITA_SAHA]

@ghudgins

Check out runtime fields in the Lens UI instead of stack management (it's newer as of 7.13) - Lens | Kibana Guide [7.13] | Elastic

You can add a script that converts the field to the appropriate data type. Really, though, if this works for you it's more performant to index the appropriate type up front (runtime fields are slower than indexed fields).

Here's an example that does the opposite of what you're trying to do. The example uses painless which exposes a lot of useful java APIs.

Long input = doc['event.duration'].value;
String output = Objects.toString(input);

emit(output);

Thank you @ghudgins for the solution