[DRILL-1641] kvgen functions fails when the input is an index within a repeated map vector

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Component/s: Execution - Relational Operators, Functions - Drill
• Assignee: Daniel Barclay
• Reporter: Rahul Kumar Challapalli
• Created: 05/Nov/14 22:16
• Updated: 06/May/15 02:18
• Resolved: 01/Dec/14 18:44

Description

git.commit.id.abbrev=6dca24a

kvgen function does not work for the below dataset which has an array of maps

{
   "col1" : [
        {"m1":"val1", "m2":"val2"},
        {"m3":"val3", "m4":"val4"}
    ]
}

Query :

0: jdbc:drill:schema=dfs> select kvgen(col1[0]) from `json_kvgenflatten/temp.json`;
Query failed: Failure while running fragment. kvgen function only supports Simple maps as input [c9bf5998-2198-4b12-a3b8-2a5a7b1e938f]

Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)

I attached the explain plan and the logs for the failing query. Let me know if you need anything else.