[
https://issues.apache.org/jira/browse/DRILL-1575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mehant Baid updated DRILL-1575:
-------------------------------
Attachment: DRILL-1575.patch
[~jaltekruse] please review minor change to ignore null values in kvgen.
> kvgen function should eliminate keys with null values
> -----------------------------------------------------
>
> Key: DRILL-1575
> URL: https://issues.apache.org/jira/browse/DRILL-1575
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Neeraja
> Assignee: Mehant Baid
> Priority: Critical
> Attachments: DRILL-1575.patch
>
>
> Here is the same JSON I am trying to query and use kvgen function with.
> {
> "name":"test",
> "myarray":{
> "key1":2,
> "key4":3,
> "key2":4
> }
> }{
> "name":"mytest",
> "myarray":{
> "key3":2,
> "key5":3,
> "key6":4
> }
> }
> Currently , when I apply kvgen a list of 'unioned' columns are returned as
> keys in the result. For ex: both the result rows below have keys 1-6.
> The expected result is only the keys that actually have values associated
> with them.
> 0: jdbc:drill:zk=local> SELECT name, kvgen(myarray) FROM
> dfs.`default`.`/Users/nrentachintala/Downloads/apache-drill-0.7.0-incubating-SNAPSHOT/sample-data/mytest.json`;
> +------------+------------+
> | name | EXPR$1 |
> +------------+------------+
> | test |
> [{"key":"key1","value":2},{"key":"key4","value":3},{"key":"key2","value":4},{"key":"key3"},{"key":"key5"},{"key":"key6"}]
> |
> | mytest |
> [{"key":"key1"},{"key":"key4"},{"key":"key2"},{"key":"key3","value":2},{"key":"key5","value":3},{"key":"key6","value":4}]
> |
> +------------+------------+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
