jean-claude created DRILL-4858: ---------------------------------- Summary: REPEATED_COUNT on JSON containing an array of maps Key: DRILL-4858 URL: https://issues.apache.org/jira/browse/DRILL-4858 Project: Apache Drill Issue Type: Bug Reporter: jean-claude Priority: Minor
REPEATED_COUNT of JSON containing an array of map does not work. JSON file {code} drill$ cat /Users/jccote/repeated_count.json {"intArray": [1,2,3,4], "mapArray": [{"name": "foo"},{"name": "foo"}], "label": "foo"} {"intArray": [1,2,3,4], "mapArray": [{"name": "foo"},{"name": "foo"}], "label": "foo"} {"intArray": [1,2,3,4], "mapArray": [{"name": "foo"},{"name": "foo"}], "label": "foo"} {"intArray": [1,2,3,4], "mapArray": [{"name": "foo"},{"name": "foo"}], "label": "foo"} {"intArray": [1,2,3,4], "mapArray": [{"name": "foo"},{"name": "foo"}], "label": "foo"} {"intArray": [1,2,3,4], "mapArray": [{"name": "foo"},{"name": "foo"}], "label": "foo"} {"intArray": [1,2,3,4], "mapArray": [{"name": "foo"},{"name": "foo"}], "label": "foo"} {"intArray": [1,2,3,4], "mapArray": [{"name": "foo"},{"name": "foo"}], "label": "foo"} {code} select {code} 0: jdbc:drill:zk=local> select repeated_count(mapArray) from dfs.`/Users/jccote/repeated_count.json`; {code} error {code} Error: SYSTEM ERROR: SchemaChangeException: Failure while trying to materialize incoming schema. Errors: Error in expression at index -1. Error: Missing function implementation: [repeated_count(MAP-REPEATED)]. Full expression: --UNKNOWN EXPRESSION--.. Fragment 0:0 [Error Id: 1057bb8e-1cc4-4a9a-a748-3a6a14092858 on 192.168.1.3:31010] (state=,code=0) {code} Looking at the org.apache.drill.exec.expr.fn.impl.SimpleRepeatedFunctions Looks like it's not enabled yet. {code} // TODO - need to confirm that these work SMP: They do not @FunctionTemplate(name = "repeated_count", scope = FunctionTemplate.FunctionScope.SIMPLE) public static class RepeatedLengthMap implements DrillSimpleFunc { {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)