[ https://issues.apache.org/jira/browse/DRILL-3032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Hanifi Gunes updated DRILL-3032: -------------------------------- Affects Version/s: 0.9.0 > Join between complex (nested repeated lists) data results in "LATE type is > not supported" > ----------------------------------------------------------------------------------------- > > Key: DRILL-3032 > URL: https://issues.apache.org/jira/browse/DRILL-3032 > Project: Apache Drill > Issue Type: Bug > Components: Execution - Data Types, Execution - Flow > Affects Versions: 0.9.0 > Reporter: Rahul Challapalli > Assignee: Hanifi Gunes > Attachments: error.log > > > git.commit.id.abbrev=4689468 > Data Set 1 : > {code} > { > "id":1, > "aaa":[[["aa0 1"], ["ab0 1"]]] > } > {code} > Data Set 2 : > {code} > {"id" : 1} > {code} > The below query fails > {code} > 0: jdbc:drill:schema=dfs_eea> select * from `file1.json` f1 inner join > `file2.json` f2 on f1.id = f2.id; > Error: SYSTEM ERROR: java.lang.UnsupportedOperationException: LATE type is > not supported. Mode: OPTIONAL > Fragment 0:0 > [Error Id: a865954d-dd29-42fc-8538-291a835a79cd on qa-node190.qa.lab:31010] > (state=,code=0) > {code} > Attached the error logs -- This message was sent by Atlassian JIRA (v6.3.4#6332)