[DRILL-2146] Flatten Function on two layer deep field fails to plan

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Component/s: Query Planning & Optimization
• Assignee: Sean Hsuan-Yi Chu
• Reporter: Sean Hsuan-Yi Chu
• Created: 03/Feb/15 01:59
• Updated: 06/May/15 20:23
• Resolved: 19/Mar/15 03:39

Description

Use the same data in DRILL-2012 to run this query:

select flatten(j.batters.batter) bb
from dfs_test.`%s` j where j.type = 'donut'

fails to plan.

Issue Links

• depends upon: DRILL-2106 Flatten together with order by on a list within a list is causing an error