Elasticsearch datasource error on sample data workpads in 6.5.3

[rayafratkina]

Kibana version: 6.5.3

Elasticsearch version: 6.5.3

Server OS version: Windows

Browser version: Chrome

Browser OS version: Windows

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

Describe the bug: Error appears on the canvas workpads that ship with these sample datasets

Steps to reproduce:

1. Install elasticsearch and Kibana w/ Basic license
2. Add sample data: web logs or ecommerce
3. Open corresponding Canvas workpad
4. Observe the error on the workpad. Click into the element to see error message: Expression failed with the message: [esdocs] > Unexpected error from Elasticsearch: [x_content_parse_exception] [1:25] [sql/query] query doesn't support values of type: START_OBJECT details: { "error": { "stack": "Error: [esdocs] > Unexpected error from Elasticsearch: [x_content_parse_exception] [1:25] [sql/query] query doesn't support values of type: START_OBJECT\n at elasticsearchClient.then.catch.e (C:/kibana-6.5.3-windows-x86_64/node_modules/x-pack/plugins/canvas/server/lib/query_es_sql.js:45:13)\n at \n at process._tickDomainCallback (internal/process/next_tick.js:229:7)", "message": "[esdocs] > Unexpected error from Elasticsearch: [x_content_parse_exception] [1:25] [sql/query] query doesn't support values of type: START_OBJECT" } }

Expected behavior: No errors

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

[alexfrancoeur]

@costin any reason why we might be getting this error?