Rahul Challapalli created DRILL-1259:
----------------------------------------
Summary: Drill changing the order of the columns when the first
record has null value for the column
Key: DRILL-1259
URL: https://issues.apache.org/jira/browse/DRILL-1259
Project: Apache Drill
Issue Type: Bug
Components: Storage - JSON
Reporter: Rahul Challapalli
git.commit.id.abbrev=98b208e
JSON File Used :
{code}
{
"a" : null,
"b" : 1
}
{
"a" : 1,
"b" : 1
}
{code}
Query : The order has changed in the below result
{code}
select * from `temp.json`;
+------------+------------+
| b | a |
+------------+------------+
| 1 | null |
| 1 | 1 |
+------------+------------+
{code}
However with the below dataset where the null field is in the second row drill
preserves the order
{code}
{
"a" : 1,
"b" : 1
}
{
"a" : null,
"b" : 1
}
{code}
Query:
{code}
select * from `temp.json`;
+------------+------------+
| a | b |
+------------+------------+
| 1 | 1 |
| null | 1 |
+------------+------------+
{code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
