[
https://issues.apache.org/jira/browse/DRILL-1062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14072158#comment-14072158
]
Chun Chang commented on DRILL-1062:
-----------------------------------
Here is the wrong result from Drill:
Canada BC Vancouver Store 19 Deluxe Supermarket Ruth
34452 27463 4193 2795 t 6644 Sudance Drive
Canada BC Victoria Store 20 Mid-Size Grocery Cobb
0 0 0 0 t 3706 Marvelle Ln
Mexico DF Mexico City Store 9 Mid-Size Grocery Stuber 34791
26354 5062 3375 f 1872 El Pintado Road
Mexico DF San Andres Store 21 Deluxe Supermarket Jones
null null null null t 4093 Steven Circle
Mexico Guerrero Acapulco Store 1 Supermarket Jones 28206
22271 3561 2374 f 2853 Bailey Rd
Mexico Jalisco Guadalajara Store 5 Small Grocery Green 23688 15337
5011 3340 t 1250 Coggins Drive
Mexico Veracruz Orizaba Store 10 Supermarket Merz 20319
16232 2452 1635 f 7894 Rotherham Dr
Mexico Yucatan Merida Store 8 Deluxe Supermarket Williams 36509
22450 8435 5624 t 3173 Buena Vista Ave
Mexico Zacatecas Camacho Store 4 Gourmet Supermarket Johnson 24597
15012 5751 3834 t 433 St George Dr
Mexico Zacatecas Hidalgo Store 12 Deluxe Supermarket Kalman
27694 18670 5415 3610 t 1120 Westchester Pl
Mexico Zacatecas Hidalgo Store 18 Mid-Size Grocery Brown
23112 16418 4016 2678 f 6764 Glen Road
USA CA Alameda HQ HeadQuarters null null null null
null f 1 Alameda Way
USA CA Beverly Hills Store 6 Gourmet Supermarket Maris 23598
14210 5633 3755 t 5495 Mitchell Canyon Road
USA CA Los Angeles Store 7 Supermarket White 30797 20141
6393 4262 f 1077 Wharf Drive
USA CA San Francisco Store 14 Small Grocery Strehlo 21215
13305 4746 3164 t 4365 Indigo Ct
USA OR Portland Store 11 Supermarket Erickson
30584 21938 5188 3458 f 5371 Holland Circle
> DRILL does not handle NULLS FIRST/LAST correctly in ORDER BY clause
> -------------------------------------------------------------------
>
> Key: DRILL-1062
> URL: https://issues.apache.org/jira/browse/DRILL-1062
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Jinfeng Ni
> Assignee: Jinfeng Ni
>
> ORDER BY clause could specify nulls first or nulls last. Currently, DRILL
> will always use nulls last policy.
> select tbl.topping[3].type from
> dfs.`/Users/jni/work/incubator-drill/exec/ref/target/test-classes/donuts.json`
> as tbl order by 1 nulls last;
> +------------+
> | EXPR$0 |
> +------------+
> | Chocolate |
> | Maple |
> | Powdered Sugar |
> | Powdered Sugar |
> | null |
> +------------+
> 5 rows selected (0.156 seconds)
> 0: jdbc:drill:zk=local> select tbl.topping[3].type from
> dfs.`/Users/jni/work/incubator-drill/exec/ref/target/test-classes/donuts.json`
> as tbl order by 1 nulls first;
> +------------+
> | EXPR$0 |
> +------------+
> | Chocolate |
> | Maple |
> | Powdered Sugar |
> | Powdered Sugar |
> | null |
> +------------+
> 5 rows selected (0.186 seconds)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
