Column ordering is incorrect when ORDER BY is used with LIMIT clause in query over parquet data

[Khurram Faraaz]

All,


This looks incorrect.


Query with order by + limit clause, the ordering of the columns returned in the 
query results is NOT the same as the column ordering in the parquet file.


{noformat}

0: jdbc:drill:schema=dfs.tmp> SELECT * FROM typeall_l ORDER BY col_int limit 1;
+----------+----------+-------------+------------+----------+-----------------+----------------+-----------+------------------------+----------------+-------------+
| col_bln  | col_chr  |   col_dt    |  col_flt   | col_int  | col_intrvl_day  | 
col_intrvl_yr  |  col_tim  |       col_tmstmp       |   col_vrchr1   | 
col_vrchr2  |
+----------+----------+-------------+------------+----------+-----------------+----------------+-----------+------------------------+----------------+-------------+
| false    | MI       | 1967-05-01  | 32.901897  | 0        | P12DT20775S     | 
P196M          | 19:50:17  | 2004-10-15 17:49:36.0  | Felecia Gourd  | NLBQMg9  
   |
+----------+----------+-------------+------------+----------+-----------------+----------------+-----------+------------------------+----------------+-------------+
1 row selected (0.279 seconds)

{noformat}

Without the ORDER BY clause the columns are returned in correct order, same as 
the ordering in the parquet file.

{noformat}
0: jdbc:drill:schema=dfs.tmp> SELECT * FROM typeall_l limit 1;
+----------+----------+----------------+---------------------------------------------------------------------------------------------------------------------+-------------+-----------+------------------------+------------+----------------+-----------------+----------+
| col_int  | col_chr  |   col_vrchr1   |                                        
             col_vrchr2                                                      |  
 col_dt    |  col_tim  |       col_tmstmp       |  col_flt   | col_intrvl_yr  | 
col_intrvl_day  | col_bln  |
+----------+----------+----------------+---------------------------------------------------------------------------------------------------------------------+-------------+-----------+------------------------+------------+----------------+-----------------+----------+
| 45436    | WV       | John Mcginity  | 
Rhbf6VFLJguvH9ejrWNkY1CDO8QqumTZAGjwa9cHfjBnLmNIWvo9YfcGObxbeXwa1NkemW9ULxsq5293wEA2v5FFCduwt03D7ysI3RlH8b4B0XAPKY
  | 2011-11-04  | 18:02:26  | 1988-09-23 16:58:42.0  | 10.193293  | P314M       
   | P26DT27386S     | false    |
+----------+----------+----------------+---------------------------------------------------------------------------------------------------------------------+-------------+-----------+------------------------+------------+----------------+-----------------+----------+
1 row selected (0.22 seconds)


{noformat}


Thanks,

Khurram