Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.incubator.apache.org
Date: Sun, 9 Nov 2014 20:31:33 +0000 (UTC)
From: "Jason Altekruse (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12753268.1415236598000.456482.1415565093689@Atlassian.JIRA>
In-Reply-To: <JIRA.12753268.1415236598000@Atlassian.JIRA>
References: <JIRA.12753268.1415236598000@Atlassian.JIRA>
 <JIRA.12753268.1415236598005@arcas>
Subject: [jira] [Commented] (DRILL-1642) flatten function is dropping the
 last record when the json file contains even no of records
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DRILL-1642?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14204100#comment-14204100 ] 

Jason Altekruse commented on DRILL-1642:
----------------------------------------

This isn't related to Drill 1608, it also is not quite an accurate diagnosis of the real problem. The issue was the number of map that were being flattened was wrong due to a bug in the repeated map vector. Drill 1643 was created for the bug, and it was determined that this solves the issue here as well.

> flatten function is dropping the last record when the json file contains even no of records
> -------------------------------------------------------------------------------------------
>
>                 Key: DRILL-1642
>                 URL: https://issues.apache.org/jira/browse/DRILL-1642
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JSON
>            Reporter: Rahul Challapalli
>            Assignee: Jason Altekruse
>         Attachments: flatten.json
>
>
> git.commit.id.abbrev=5adadfa
> The below query does not produce the right output. It is missing the last record from the data file. The record count is even for the data set. However if it is odd, the flatten operator has not issues .
> {code}
> 0: jdbc:drill:schema=dfs> select rownum, flatten(complex) from `flatten.json`;
> +------------+------------+
> |   rownum   |   EXPR$1   |
> +------------+------------+
> | 1          | {"col1":3} |
> | 1          | {"col2":2,"col3":1} |
> | 1          | {"col1":7} |
> | 2          | {"col2":2,"col3":1} |
> | 2          | {"col1":7} |
> | 3          | {"col1":2,"col3":1} |
> +------------+------------+
> {code} 
> Attached the data file. Let me know if you need anything more.


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)