[jira] [Commented] (DRILL-3032) Join between complex (nested repeated lists) data results in "LATE type is not supported"

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-3032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14552992#comment-14552992 ] 

Rahul Challapalli commented on DRILL-3032:
------------------------------------------

Query without using a '*' to reproduce the same error
{code}
select f1.aaa, f2.aaa from `json_storage/file1.json` f1 inner join `json_storage/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: 47b0d156-8376-4375-9302-a8fb1e2bfed6 on qa-node191.qa.lab:31010] (state=,code=0)
{code}

> 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
>    Affects Versions: 0.9.0
>            Reporter: Rahul Challapalli
>            Assignee: Hanifi Gunes
>             Fix For: 1.1.0
>
>         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)