Canvas: Default SQL statement produces error with sample data

[flash1293]

Kibana version: master

Elasticsearch version:

Server OS version:

Browser version:

Browser OS version:

Original install method (e.g. download page, yum, from source, etc.):

Describe the bug: Currently the default SQL query (SELECT * FROM "kibana_sample_data_ecommerce") produces an error because the index contains error fields:

[essql] > Unexpected error from Elasticsearch: [sql_illegal_argument_exception] Arrays (returned by [manufacturer]) are not supported

This is also the case for the logs sample data.

Steps to reproduce:

1. Crate fresh Kibana instance with only sample data sets
2. Create new canvas workpad
3. Add new element
4. Switch data to SQL

Expected behavior:

Getting started with sql in canvas isn't as seamless as it could be because of this. Maybe the default query should not select * but just the time field of the default index (which is very likely not an array field)?

This is not a big issue, but it would make getting started with essql easier if the default query would work with the sample data sets.

Screenshots (if relevant):

Errors in browser console (if relevant):

Provide logs and/or server output (if relevant):

Any additional context:

[elasticmachine]

Pinging @elastic/kibana-canvas (Team:Canvas)

[poffdeluxe]

Took a look at this a bit and it's certainly an issue with the sample data. Changing the default query would be easy but we'd still have to pick some fields.