[
https://issues.apache.org/jira/browse/IMPALA-12019?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17793950#comment-17793950
]
ASF subversion and git services commented on IMPALA-12019:
----------------------------------------------------------
Commit 6b47c40e0dd808793203eeac2994260f0fc47753 in impala's branch
refs/heads/master from Daniel Becker
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=6b47c40e0 ]
IMPALA-12159: Support ORDER BY for collections of variable length types in
select list
IMPALA-12019 implemented support for collections of fixed length types
in the sorting tuple. This change implements it for collections of
variable length types.
Note that the limitation that structs that contain any type of
collection are not allowed in the sorting tuple is still in place (see
IMPALA-12160).
Note that it was not and still is not allowed to sort by complex types,
this change only allows them to be present in the select list when
sortin by some other expression.
This change also allows collections of variable length types to be
non-passthrough children of UNION ALL nodes.
Testing:
- Renamed the 'simple_arrays_big' table to 'arrays_big' and extended it
with collections containing variable length types. This table is
mainly used to test that spilling works during sorting.
- Renamed
test_sort.py::TestArraySort::{test_simple_arrays,
test_simple_arrays_with_limit}
to {test_array_sort,test_array_sort_with_limit}
- Extended the tests run in test_queries.py::TestQueries::{test_sort,
test_top_n,test_partitioned_top_n} with collections containing
var-len types.
- Added tests in sort-complex.test that assert that it is not allowed
to sort by collections. For structs we already have such tests in
struct-in-select-list.test.
Change-Id: Ic15b29393f260b572e11a8dbb9deeb8c02981852
Reviewed-on: http://gerrit.cloudera.org:8080/20108
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
> Support ORDER BY for collections of fixed length types in select list
> ---------------------------------------------------------------------
>
> Key: IMPALA-12019
> URL: https://issues.apache.org/jira/browse/IMPALA-12019
> Project: IMPALA
> Issue Type: Sub-task
> Components: Backend, Frontend
> Reporter: Daniel Becker
> Assignee: Daniel Becker
> Priority: Major
> Fix For: Impala 4.3.0
>
>
> As a first stage of IMPALA-10939, we should implement support for ORDER BY
> for arrays that only contain fixed length types. That way the implementation
> could be almost the same as the existing handling of strings.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
