Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.incubator.apache.org
Date: Thu, 6 Nov 2014 01:17:33 +0000 (UTC)
From: "Rahul Challapalli (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12753268.1415236598000.430168.1415236653935@Atlassian.JIRA>
In-Reply-To: <JIRA.12753268.1415236598000@Atlassian.JIRA>
References: <JIRA.12753268.1415236598000@Atlassian.JIRA>
 <JIRA.12753268.1415236598005@arcas>
Subject: [jira] [Created] (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

Rahul Challapalli created DRILL-1642:
----------------------------------------

             Summary: 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
            Reporter: Rahul Challapalli
         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)