[DRILL-1259] Drill changing the order of the columns when the first record has null value for the column

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Fix Version/s: 0.5.0
• Component/s: Storage - JSON
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 05/Aug/14 23:25
• Updated: 01/May/15 22:44
• Resolved: 10/Aug/14 22:07

Description

git.commit.id.abbrev=98b208e

JSON File Used :

{
  "a" : null,
  "b" : 1
}
{
  "a" : 1,
  "b" : 1
}

Query : The order has changed in the below result

select * from `temp.json`;
+------------+------------+
|     b      |     a      |
+------------+------------+
| 1          | null       |
| 1          | 1          |
+------------+------------+

However with the below dataset where the null field is in the second row drill preserves the order

{
  "a" : 1,
  "b" : 1
}
{
  "a" : null,
  "b" : 1
}

Query:

select * from `temp.json`;
+------------+------------+
|     a      |     b      |
+------------+------------+
| 1          | 1          |
| null       | 1          |
+------------+------------+