[jira] [Commented] (DRILL-2953) Group By + Order By query results are not ordered.

[ https://issues.apache.org/jira/browse/DRILL-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15059657#comment-15059657 ] Khurram Faraaz commented on DRILL-2953: --- Verified Fix on Drill 1.4, test needs to be added. {code}

[jira] [Commented] (DRILL-2953) Group By + Order By query results are not ordered.

[ https://issues.apache.org/jira/browse/DRILL-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14539307#comment-14539307 ] Jinfeng Ni commented on DRILL-2953: --- I could not locate the exact cause of the problem.

[jira] [Commented] (DRILL-2953) Group By + Order By query results are not ordered.

[ https://issues.apache.org/jira/browse/DRILL-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14538939#comment-14538939 ] Jinfeng Ni commented on DRILL-2953: --- Skipping the middle CAST(b) means the output of

[jira] [Commented] (DRILL-2953) Group By + Order By query results are not ordered.

[ https://issues.apache.org/jira/browse/DRILL-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14538914#comment-14538914 ] Aman Sinha commented on DRILL-2953: --- Will this work for something like: ORDER BY a,

[jira] [Commented] (DRILL-2953) Group By + Order By query results are not ordered.

[ https://issues.apache.org/jira/browse/DRILL-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14538988#comment-14538988 ] Jinfeng Ni commented on DRILL-2953: --- One more case: {code} select cast(columns[0] as

[jira] [Commented] (DRILL-2953) Group By + Order By query results are not ordered.

[ https://issues.apache.org/jira/browse/DRILL-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14539020#comment-14539020 ] Aman Sinha commented on DRILL-2953: --- Yes, the plans look good, adding the sort after the

[jira] [Commented] (DRILL-2953) Group By + Order By query results are not ordered.

[ https://issues.apache.org/jira/browse/DRILL-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14538797#comment-14538797 ] Jinfeng Ni commented on DRILL-2953: --- [~amansinha100], could you please review the patch

[jira] [Commented] (DRILL-2953) Group By + Order By query results are not ordered.

[ https://issues.apache.org/jira/browse/DRILL-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14527514#comment-14527514 ] Khurram Faraaz commented on DRILL-2953: --- There is another case, when we cast the

[jira] [Commented] (DRILL-2953) Group By + Order By query results are not ordered.

[ https://issues.apache.org/jira/browse/DRILL-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14527544#comment-14527544 ] Jinfeng Ni commented on DRILL-2953: --- There seems to be a bug in planner. The the first

[jira] [Commented] (DRILL-2953) Group By + Order By query results are not ordered.

[ https://issues.apache.org/jira/browse/DRILL-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14527499#comment-14527499 ] Khurram Faraaz commented on DRILL-2953: --- I tried casting to integer in the order by

[jira] [Commented] (DRILL-2953) Group By + Order By query results are not ordered.

[ https://issues.apache.org/jira/browse/DRILL-2953?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14527382#comment-14527382 ] Jason Altekruse commented on DRILL-2953: All data read out of csv will be read as