[ https://issues.apache.org/jira/browse/DRILL-4858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15430950#comment-15430950 ]
jean-claude commented on DRILL-4858: ------------------------------------ {code} 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"}], "label": "foo"} {"intArray": [1,2,3,4], "mapArray": [], "label": "foo"} {"intArray": [1,2,3,4], "mapArray": [{"name": "foo"},{"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"},{"name": "foo"},{"name": "foo"}], "label": "foo"} {"intArray": [1,2,3,4], "mapArray": [{"name": "foo"},{"name": "foo"}], "label": "foo"} {code} results in {code} 0: jdbc:drill:zk=local> select repeated_count(mapArray) from dfs.`/Users/jccote/repeated_count.json`; +---------+ | EXPR$0 | +---------+ | 2 | | 1 | | 0 | | 3 | | 2 | | 2 | | 4 | | 2 | +---------+ 8 rows selected (2.598 seconds) {code} > 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)