Lens only shows keyword fields, not text fields

[jportner]

Kibana version: Verified in 7.11.1, 7.12.0, 7.13.0-SNAPSHOT, and master

Describe the bug: Lens only shows keyword fields, not text fields

Steps to reproduce:

1. Create a test document in Dev Tools:

   POST test/_doc
   {
     "link": "https://www.example.com"
   }
   

2. Create an Index Pattern for this document:
   
3. Create a Lens Visualization:
   

Expected behavior: Lens should show both link and link.keyword in the available fields

[elasticmachine]

Pinging @elastic/kibana-app (Team:KibanaApp)

[wylieconlon]

@jportner these are hidden from Lens because we currently don't allow you to visualize the full-text fields. We might be able to display them in a Data Table visualization in the future.

[timductive]

Closing this as text fields in a datatable are supported in ESQL along with aggregations.

[harnish-elastic]

Hi @timductive,

In the IBM MQ package, one field (ibmmq.errorlog.error.description) has the text data type which was used in the TSVB table visualization. However, we are still not able to visualize in the lens. We have checked in the multiple Kibana versions (8.9.x, 8.10.x, 8.11.0). Hence, we are still blocked on IBM MQ lens migration for one panel. Could you please help me out?

TSVB: Visualization working as expected

Lens: The text field is not visualizable

[stratoula]

@harnish-elastic you wont be able to do it with Lens or TSVB as they only work with aggregatable fields and the text fields are not (from ES)

But from 8.11 you have ES|QL where it will allow you to create visualizations with text fields.

I will give an example:

• Navigate to Discover and ESQL mode
• Run a query such as from logstash-* | stats var0 = avg(bytes) by host
• Host is a text field
• This results to

• You can save this visualization to a dashboard