Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4605

Flatten doesn't return nested arrays correctly when Union is enabled

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      File:

      {a:[[1,2,3], [4]]}
      
      set `exec.enable_union_type` = false;
      
      select flatten(a) as a from dfs.tmp.`blue.json`;
      +----------+
      |    a     |
      +----------+
      | [1,2,3]  |
      | [4]      |
      +----------+
      
      set `exec.enable_union_type` = true;
      
      select flatten(a) as a from dfs.tmp.`blue.json`;
      +-------+
      |   a   |
      +-------+
      | null  |
      | null  |
      +-------+
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jnadeau Jacques Nadeau
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: