[BUG] Discover can't sort directly on some half_float columns

[ananzh]

Describe the bug Seems some mapping field are not able to be sorted even sortable property is true. I have added detailed reproduce steps below.

To Reproduce Steps to reproduce the behavior:

1. Go to Discover and use sample ecommerse data using playgroud.

2. Add field customer_gender and taxless_total_price.

3. Sort by 'customer_gender' and make sure we don't sort on time (need to click twice on time)

   

4. Sort by taxless_total_price. You could see taxless_total_price is sortable for Female and Male.

   

5. Remove customer_gender column to only sort on taxless_total_price. See errors

   

Expected behavior No error or more guidable error message.

OpenSearch Version any

Dashboards Version any

Plugins

Please list all plugins currently enabled.

Screenshots

If applicable, add screenshots to help explain your problem.

Host/Environment (please complete the following information):

• OS: [e.g. iOS]
• Browser and version [e.g. 22]

Additional context

Add any other context about the problem here.

[SamriddhiS2]

I'd be interested in taking this one!