[DRILL-455] Inconsistent order of the fields between the SQL query and results

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Unassigned
• Reporter: Neeraja
• Created: 26/Mar/14 23:05
• Updated: 31/Jul/14 06:33
• Resolved: 29/May/14 17:47

Description

Performed the following query and expect the results to have the same order of fields specified in query i.e l_returnflag first followed by l_linestatus followed by count. Currently the order is not obeyed.

0: jdbc:drill:> select l_returnflag,l_linestatus, count from lineitem group by l_returnflag, l_linestatus order by l_returnflag,l_linestatus;
------------------------------------

EXPR$2

l_returnflag

l_linestatus

------------------------------------

147790	A	F
3765	N	F
0	N	O
300716	N	O
148301	R	F

------------------------------------