Workbench: error message is not returned properly

[dai-chen]

Currently the workbench seems showing "[Index name]: no response" for any error.

[dai-chen]

For example, the SQL plugin throws semantic exception for the unknown field number in index accounts. However, the error message is not returned to customer properly.

SELECT ABS(number) FROM accounts LIMIT 5;

Accounts: no response

[penghuo]

+1

Query

SELECT NotExistName, MAX(FlightDelayMin)
FROM kibana_sample_data_flights
GROUP BY DestCityName

Result in sql-kibana is unexpected

Kibana_sample_data_flights
group: no response

Result in devtools is expected

{
  "error": {
    "reason": "Invalid SQL query",
    "details": "Field [NotExistName] cannot be found or used here.",
    "type": "SemanticAnalysisException"
  },
  "status": 400
}

[chloe-zh]

Duplicated issue with opendistro-for-elasticsearch/sql-workbench#16

[matanrabi]

@dai-chen Was this issue resolved? I'm getting the same problems while working with kibana SQL work bench

[dai-chen]

@matanrabi Sorry I got it wrong about PR https://github.com/opendistro-for-elasticsearch/sql/pull/943. I just confirmed with @chloe-zh. The fix in this PR is only on rc3 branch now. We need to merge this to develop branch.