Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Fri, 11 Sep 2015 18:12:47 +0000 (UTC)
From: "Kristine Hahn (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.12823481.1429810882000.317141.1441995167573@Atlassian.JIRA>
In-Reply-To: <JIRA.12823481.1429810882000@Atlassian.JIRA>
References: <JIRA.12823481.1429810882000@Atlassian.JIRA>
 <JIRA.12823481.1429810882561@arcas>
Subject: [jira] [Closed] (DRILL-2854) KVGEN function document needs to be
 corrected
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ 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)