<catalog>.<table> syntax not supported

[jordanw-bq]

Low priority issue; we could not find this syntax specifically used with Tableau, but other BI tools and JDBC applications may use this type of syntax.

Somewhat similar to #213, but this appears in the FROM clause.

Using Docker image amazon/opendistro-for-elasticsearch:1.1.0
Dataset: Flights sample data (loaded through Kibana)
SQL Plugin version: 1.1.0.1

Example Query:
SELECT Carrier FROM odfe-cluster.kibana_sample_data_flights

Results

Raw response received: {
  "error": {
    "reason": "Invalid SQL query",
    "details": "Field [odfe-cluster.kibana_sample_data_flights] cannot be found or used here.",
    "type": "SemanticAnalysisException"
  },
  "status": 400
}

Expectation:
Able to recognize this as a qualified table name in the odfe-cluster catalog.

[dai-chen]

I assume odfe-cluster is your ES cluster name configured in ES config yml. Need to check if we have this information in plugin code.

[jordanw-bq]

Yes, this is the our configured cluster name.