You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2018/11/06 18:27:00 UTC
[jira] [Commented] (IMPALA-1354) Crash in analytic ordered by
constant
[ https://issues.apache.org/jira/browse/IMPALA-1354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16677133#comment-16677133 ]
ASF subversion and git services commented on IMPALA-1354:
---------------------------------------------------------
Commit cf89c73485c119d5068be1cdddf1acbd3c8acfd5 in impala's branch refs/heads/master from [~mostrows]
[ https://git-wip-us.apache.org/repos/asf?p=impala.git;h=cf89c73 ]
IMPALA-6323 Allow constant analytic window expressions.
The constraint imposed by IMPALA-1354 was artificial.
If there are constant "partition by" expressions, simply drop them,
they are no-ops.
Constant "order by" expressions can be ignored as well, though in effect
they should be accounted for as null expressions in the backend, with the
effect that combine all rows in the same window (i.e. no window breaks).
Change-Id: Idf129026c45120e9470df601268863634037908c
Reviewed-on: http://gerrit.cloudera.org:8080/11556
Tested-by: Impala Public Jenkins <im...@cloudera.com>
Reviewed-by: Michael Ho <kw...@cloudera.com>
> Crash in analytic ordered by constant
> -------------------------------------
>
> Key: IMPALA-1354
> URL: https://issues.apache.org/jira/browse/IMPALA-1354
> Project: IMPALA
> Issue Type: Bug
> Affects Versions: Impala 2.0
> Reporter: casey
> Assignee: Matthew Jacobs
> Priority: Major
> Fix For: Impala 2.1
>
>
> This came up while investigating another issue. I'm not sure there's a good use case for this ORDER BY but crashing is never good.
> {noformat}
> Query: select rank() over (order by 1) from alltypestiny
> Socket error 104: Connection reset by peer
> {noformat}
> stack trace
> {noformat}
> (gdb) bt
> #0 0x0000003a0ca32635 in raise () from /lib64/libc.so.6
> #1 0x0000003a0ca33e15 in abort () from /lib64/libc.so.6
> #2 0x00007f562e8e2727 in os::abort(bool) ()
> from /opt/toolchain/sun-jdk-64bit-1.6.0.31/jre/lib/amd64/server/libjvm.so
> #3 0x00007f562ea35cc8 in VMError::report_and_die() ()
> from /opt/toolchain/sun-jdk-64bit-1.6.0.31/jre/lib/amd64/server/libjvm.so
> #4 0x00007f562e8e90e5 in JVM_handle_linux_signal ()
> from /opt/toolchain/sun-jdk-64bit-1.6.0.31/jre/lib/amd64/server/libjvm.so
> #5 0x00007f562e8e53ee in signalHandler(int, siginfo*, void*) ()
> from /opt/toolchain/sun-jdk-64bit-1.6.0.31/jre/lib/amd64/server/libjvm.so
> #6 <signal handler called>
> #7 0x0000000001538633 in impala::Sorter::TupleSorter::TupleSorter (this=0x8dcd600,
> comp=..., block_size=8388608, tuple_size=0, state=0x6040a00)
> at /data/9/query-gen/Impala/be/src/runtime/sorter.cc:746
> #8 0x0000000001538e6b in impala::Sorter::Sorter (this=0x790b340, compare_less_than=...,
> slot_materialize_expr_ctxs=std::vector of length 0, capacity 0,
> output_row_desc=0x71e78a8, mem_tracker=0x790a000, profile=0x8aec900, state=0x6040a00)
> at /data/9/query-gen/Impala/be/src/runtime/sorter.cc:865
> #9 0x00000000014dacc7 in impala::SortNode::Open (this=0x71e7860, state=0x6040a00)
> at /data/9/query-gen/Impala/be/src/exec/sort-node.cc:63
> {noformat}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org