druid icon indicating copy to clipboard operation
druid copied to clipboard

Native queries: joining with inline data sources results in an error.

Open oskar11120 opened this issue 1 year ago • 0 comments

Affected Version

28.0.1

Description

Example query against wikipedia edits example datasource ingested using web console:

{
  "queryType": "scan",
  "intervals": [
    "2016-06-27T00:00:00.0000000+00:00/2016-06-28T00:00:00.0000000+00:00"
  ],
  "limit": 100,
  "dataSource": {
    "type": "join",
    "left": "wikipedia",
    "right": {
      "type": "inline",
      "rows": [
        [
          "US",
          "United States"
        ]
      ],
      "columnNames": [
        "Code",
        "FullName"
      ]
    },
    "rightPrefix": "r.",
    "condition": "countryIsoCode == r.Code",
    "joinType": "LEFT"
  }
}

Error: image

oskar11120 avatar Mar 09 '24 23:03 oskar11120