[
https://issues.apache.org/jira/browse/DRILL-2854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kristine Hahn closed DRILL-2854.
--------------------------------
> KVGEN function document needs to be corrected
> ---------------------------------------------
>
> Key: DRILL-2854
> URL: https://issues.apache.org/jira/browse/DRILL-2854
> Project: Apache Drill
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 0.9.0
> Reporter: Khurram Faraaz
> Assignee: Kristine Hahn
>
> The sample JSON data snippet here (http://drill.apache.org/docs/kvgen/) needs
> to be corrected and additionally the SQL query to produce the output listed
> in that section, can be added to that section.
> Here is the correct representation of the data in the JSON data file.
> Currently the text on documentation page is missing the "rec1" identifier,
> and the opening and closing braces for "rec1" are also missing.
> {code}
> [root@centos-01 bin]# hadoop fs -cat /tmp/simplemaps.json
> {"rec1":{"a": "valA", "b": "valB"}}
> {"rec1":{"c": "valC", "d": "valD"}}
> {code}
> Query that produces the desired output, like the one mentioned in the
> documentation section for KVGEN function.
> {code}
> 0: jdbc:drill:> select kvgen(rec1) from `simplemaps.json`;
> +------------+
> | EXPR$0 |
> +------------+
> | [{"key":"a","value":"valA"},{"key":"b","value":"valB"}] |
> | [{"key":"c","value":"valC"},{"key":"d","value":"valD"}] |
> +------------+
> 2 rows selected (0.201 seconds)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
