[DRILL-1771] Doing a flatten along with selecting a column from a subquery which does a flatten over kvgen results in a planning error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Component/s: Functions - Drill, Storage - JSON
• Assignee: Daniel Barclay
• Reporter: Rahul Kumar Challapalli
• Created: 21/Nov/14 04:03
• Updated: 24/Apr/15 20:43
• Resolved: 01/Dec/14 00:13

Description

git.commit.id.abbrev=108d29f

Dataset :

{"map":{"rm": [ {"rptd": [{ "a": "foo"}]}]}}

Query :

select sub.fk.key, flatten(sub.fk.`value`) from (select flatten(kvgen(map)) fk from `json_kvgenflatten/nested3.json` limit 1) sub;
Query failed: Failure while setting up Foreman.

Error: exception while executing query: Failure while executing query. (state=,code=0)

I attached the error log. Let me know if you need anything more