<catalog>.<table> syntax not supported

jordanw-bq commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

Yes, this is the our configured cluster name.

opendistro-for-elasticsearch / sql

<catalog>.<table> syntax not supported #238