[DRILL-4912] Ability to use alias in join conditions - ASF JIRA

XML

Word

Printable

JSON

Json files used for testing:

data.json

{ "name": "Jim","city" : [1,2]}

cities.json

{id:1,name:"Sendurai"} {id:2,name:"NYC"}

Below query returns no result.

select city[0] as cityalias from dfs.tmp.`data.json` a join (select id as idalias from dfs.tmp.`cities.json`) b on a.cityalias = b.idalias

However, the query below works fine

select city[0] as cityalias from dfs.tmp.`data.json` a join (select id as idalias from dfs.tmp.`cities.json`) b on a.city[0] = b.idalias

Using an alias for city[0] in the join condition makes it return no result.

is related to

DRILL-1248 Add support for using aliases in group by