Skip to content
This repository has been archived by the owner on Aug 2, 2022. It is now read-only.

Add support for JOINs without aliases #232

Closed
jordanw-bq opened this issue Oct 18, 2019 · 1 comment
Closed

Add support for JOINs without aliases #232

jordanw-bq opened this issue Oct 18, 2019 · 1 comment
Labels
BI integration Issues for integration with BI tools enhancement New feature or request

Comments

@jordanw-bq
Copy link
Contributor

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

Example Query:
SELECT AvgTicketPrice AS AvgTicketPrice, Cancelled AS Cancelled, Carrier AS Carrier, DestAirportID AS DestAirportID, DestCityName AS DestCityName, DestCountry AS DestCountry, DestLocation AS DestLocation FROM kibana_sample_data_ecommerce LEFT JOIN kibana_sample_data_flights ON (kibana_sample_data_ecommerce.day_of_week_i = dayOfWeek) LIMIT 50

Results:
No data

{
  "schema": [],
  "total": 10000,
  "datarows": [
    [],
    [],
    [],
    [],
...
    []
  ],
  "size": 50,
  "status": 200
}

Notes:
This is a known limitation of JOINs with Elasticsearch, but Tableau by default will be generating JOINs without aliases.

Expectation:
Support for JOINs without alias

@dai-chen dai-chen added BI integration Issues for integration with BI tools enhancement New feature or request labels Oct 18, 2019
@dai-chen
Copy link
Member

Currently alias is required for JOIN.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
BI integration Issues for integration with BI tools enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants