Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
Impala 2.5.0
Description
Query:
USE functional;
SELECT
COALESCE(t1.smallint_col, t1.id, t1.day) AS int_col,
COALESCE(724, COALESCE(-420, 307, LEAD(996, 13) OVER (ORDER BY COALESCE(t1.smallint_col, t1.id, t1.day) DESC, COALESCE(t12.timestamp_col, t1.timestamp_col, t12.timestamp_col) ASC)), COALESCE(-674, -427)) AS int_col_t13,
COALESCE(COUNT(t1.day), COALESCE(t1.smallint_col, t1.id, t1.day), COALESCE(t1.smallint_col, t1.id, t1.day)) AS int_col_t14,
COALESCE(SUM(COALESCE(t1.smallint_col, t1.month, LEAST(COALESCE(t1.bigint_col, 382), COALESCE(t1.month, 485)))), COALESCE(t1.smallint_col, t1.id, t1.day), COALESCE(t1.smallint_col, t1.id, t1.day)) AS int_col_t15,
COALESCE(t12.timestamp_col, t1.timestamp_col, t12.timestamp_col) AS timestamp_col
FROM alltypesagg t1
LEFT JOIN (
SELECT
CAST(-849 AS STRING) AS char_col,
t9.boolean_col AS boolean_col,
(NULL) IN (945, NULL) AS boolean_col_t10,
(-560) IN (694, 44) AS boolean_col_t11,
COALESCE(t9.timestamp_col, t9.timestamp_col) AS timestamp_col
FROM (
WITH with_1 AS (SELECT
t3.id AS int_col,
LAG(696, 7) OVER (ORDER BY t3.id DESC, GREATEST(COALESCE(SUM(COALESCE(t3.day, t3.tinyint_col, t3.smallint_col)), 971), COALESCE(t3.id, 888))) AS int_col_t4,
GREATEST(COALESCE(SUM(COALESCE(t3.day, t3.tinyint_col, t3.smallint_col)), 971), COALESCE(t3.id, 888)) AS int_col_t5,
(COALESCE((482) * (31), -413)) * (FIRST_VALUE(-115) OVER (ORDER BY t3.id DESC, GREATEST(COALESCE(SUM(COALESCE(t3.day, t3.tinyint_col, t3.smallint_col)), 971), COALESCE(t3.id, 888)) DESC ROWS BETWEEN 81 PRECEDING AND 91 FOLLOWING)) AS int_col_t6
FROM alltypestiny t2
INNER JOIN alltypesagg t3 ON (((t3.month) = (t2.tinyint_col)) AND ((t3.day) = (t2.tinyint_col))) AND ((t3.string_col) = (t2.date_string_col))
GROUP BY
t3.id)
SELECT
(t7.int_col) IN (t8.day, t7.int_col) AS boolean_col,
LAG(CAST('1999-07-27 00:00:00' AS TIMESTAMP), 34) OVER (ORDER BY (t7.int_col) IN (t8.day, t7.int_col) DESC) AS timestamp_col
FROM alltypes t7
LEFT JOIN alltypesagg t8 ON (((((t8.day) = (t7.tinyint_col)) AND ((t8.id) = (t7.bigint_col))) AND ((t8.bigint_col) = (t7.year))) AND ((t8.date_string_col) = (t7.date_string_col))) AND ((t8.date_string_col) = (t7.date_string_col))
) t9
) t12 ON ((t12.timestamp_col) = (t1.timestamp_col)) AND ((t12.char_col) = (t1.date_string_col))
WHERE
(t1.smallint_col) NOT IN (t1.int_col, t1.id)
GROUP BY
COALESCE(t1.smallint_col, t1.id, t1.day),
COALESCE(t12.timestamp_col, t1.timestamp_col, t12.timestamp_col)
HAVING
(MIN(COALESCE(t1.smallint_col, t1.id, t1.day))) IN (SUM(-10.22), (COALESCE(t1.smallint_col, t1.id, t1.day)) + (COALESCE(t1.smallint_col, t1.id, t1.day)));
Stack Trace:
#0 0x00007f5d302b7cc9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #1 0x00007f5d302bb0d8 in __GI_abort () at abort.c:89 #2 0x00000000021a0f59 in google::DumpStackTraceAndExit() () #3 0x000000000219a3cd in google::LogMessage::Fail() () #4 0x000000000219ccf6 in google::LogMessage::SendToLog() () #5 0x0000000002199eed in google::LogMessage::Flush() () #6 0x000000000219d79e in google::LogMessageFatal::~LogMessageFatal() () #7 0x00000000012b660c in impala::RowDescriptor::GetTupleIdx (this=0x11fb1248, id=8) at /home/dev/Impala/be/src/runtime/descriptors.cc:402 #8 0x00000000010fe896 in impala::TupleIsNullPredicate::Prepare (this=0xea6c800, state=0x1671d600, row_desc=..., ctx=0x10272c00) at /home/dev/Impala/be/src/exprs/tuple-is-null-predicate.cc:45 #9 0x000000000108c501 in impala::ExprContext::Prepare (this=0x10272c00, state=0x1671d600, row_desc=..., tracker=0x14eafa20) at /home/dev/Impala/be/src/exprs/expr-context.cc:53 #10 0x00000000010776f6 in impala::Expr::Prepare (ctxs=..., state=0x1671d600, row_desc=..., tracker=0x14eafa20) at /home/dev/Impala/be/src/exprs/expr.cc:357 #11 0x000000000176a33e in impala::SortExecExprs::Prepare (this=0x13a49d48, state=0x1671d600, child_row_desc=..., output_row_desc=..., expr_mem_tracker=0x14eafa20) at /home/dev/Impala/be/src/exec/sort-exec-exprs.cc:52 #12 0x000000000176ac8c in impala::SortNode::Prepare (this=0x13a49c00, state=0x1671d600) at /home/dev/Impala/be/src/exec/sort-node.cc:46 #13 0x0000000001644402 in impala::PlanFragmentExecutor::Prepare (this=0x9eb3428, request=...) at /home/dev/Impala/be/src/runtime/plan-fragment-executor.cc:236 #14 0x0000000001469b8f in impala::FragmentMgr::FragmentExecState::Prepare (this=0x9eb3200, exec_params=...) at /home/dev/Impala/be/src/service/fragment-exec-state.cc:44 #15 0x000000000146187b in impala::FragmentMgr::ExecPlanFragment (this=0xe1c7020, exec_params=...) at /home/dev/Impala/be/src/service/fragment-mgr.cc:64 #16 0x00000000013d354b in impala::ImpalaInternalService::ExecPlanFragment (this=0xea99890, return_val=..., params=...) at /home/dev/Impala/be/src/service/impala-internal-service.h:37 #17 0x000000000157a36c in impala::ImpalaInternalServiceProcessor::process_ExecPlanFragment (this=0xe1c6fc0, seqid=0, iprot=0x12b90e00, oprot=0x13a21a00, callContext=0x1259ff00) at /home/dev/Impala/be/generated-sources/gen-cpp/ImpalaInternalService.cpp:949 #18 0x000000000157a0ba in impala::ImpalaInternalServiceProcessor::dispatchCall (this=0xe1c6fc0, iprot=0x12b90e00, oprot=0x13a21a00, fname=..., seqid=0, callContext=0x1259ff00) at /home/dev/Impala/be/generated-sources/gen-cpp/ImpalaInternalService.cpp:922 #19 0x00000000013ca532 in apache::thrift::TDispatchProcessor::process (this=0xe1c6fc0, in=..., out=..., connectionContext=0x1259ff00) at /home/dev/Impala/toolchain/thrift-0.9.0-p2/include/thrift/TDispatchProcessor.h:121 #20 0x0000000002152bbf in apache::thrift::server::TThreadedServer::Task::run() () #21 0x00000000012b16ef in impala::ThriftThread::RunRunnable (this=0x13a20180, runnable=..., promise=0x7f5cd4d7f690) at /home/dev/Impala/be/src/rpc/thrift-thread.cc:61 #22 0x00000000012b2e3f in boost::_mfi::mf2<void, impala::ThriftThread, boost::shared_ptr<apache::thrift::concurrency::Runnable>, impala::Promise<unsigned long>*>::operator() (this=0x13b5db00, p=0x13a20180, a1=..., a2=0x7f5cd4d7f690) at /home/dev/Impala/toolchain/boost-1.57.0/include/boost/bind/mem_fn_template.hpp:280 #23 0x00000000012b2cd5 in boost::_bi::list3<boost::_bi::value<impala::ThriftThread*>, boost::_bi::value<boost::shared_ptr<apache::thrift::concurrency::Runnable> >, boost::_bi::value<impala::Promise<unsigned long>*> >::operator()<boost::_mfi::mf2<void, impala::ThriftThread, boost::shared_ptr<apache::thrift::concurrency::Runnable>, impala::Promise<unsigned long>*>, boost::_bi::list0> (this=0x13b5db10, f=..., a=...) at /home/dev/Impala/toolchain/boost-1.57.0/include/boost/bind/bind.hpp:392 #24 0x00000000012b2a21 in boost::_bi::bind_t<void, boost::_mfi::mf2<void, impala::ThriftThread, boost::shared_ptr<apache::thrift::concurrency::Runnable>, impala::Promise<unsigned long>*>, boost::_bi::list3<boost::_bi::value<impala::ThriftThread*>, boost::_bi::value<boost::shared_ptr<apache::thrift::concurrency::Runnable> >, boost::_bi::value<impala::Promise<unsigned long>*> > >::operator() (this=0x13b5db00) at /home/dev/Impala/toolchain/boost-1.57.0/include/boost/bind/bind_template.hpp:20 #25 0x00000000012b2934 in boost::detail::function::void_function_obj_invoker0<boost::_bi::bind_t<void, boost::_mfi::mf2<void, impala::ThriftThread, boost::shared_ptr<apache::thrift::concurrency::Runnable>, impala::Promise<unsigned long>*>, boost::_bi::list3<boost::_bi::value<impala::ThriftThread*>, boost::_bi::value<boost::shared_ptr<apache::thrift::concurrency::Runnable> >, boost::_bi::value<impala::Promise<unsigned long>*> > >, void>::invoke (function_obj_ptr=...) at /home/dev/Impala/toolchain/boost-1.57.0/include/boost/function/function_template.hpp:153 #26 0x00000000012e79be in boost::function0<void>::operator() (this=0x7f5c78aafde0) at /home/dev/Impala/toolchain/boost-1.57.0/include/boost/function/function_template.hpp:767 #27 0x0000000001510879 in impala::Thread::SuperviseThread(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*) (name=..., category=..., functor=..., thread_started=0x7f5cd4d7f480) at /home/dev/Impala/be/src/util/thread.cc:316 #28 0x0000000001519046 in boost::_bi::list4<boost::_bi::value<std::string>, boost::_bi::value<std::string>, boost::_bi::value<boost::function<void ()> >, boost::_bi::value<impala::Promise<long>*> >::operator()<void (*)(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*), boost::_bi::list0>(boost::_bi::type<void>, void (*&)(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*), boost::_bi::list0&, int) (this=0x135107c0, f=@0x135107b8: 0x15105b4 <impala::Thread::SuperviseThread(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*)>, a=...) at /home/dev/Impala/toolchain/boost-1.57.0/include/boost/bind/bind.hpp:457 #29 0x0000000001518f89 in boost::_bi::bind_t<void, void (*)(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*), boost::_bi::list4<boost::_bi::value<std::string>, boost::_bi::value<std::string>, boost::_bi::value<boost::function<void ()> >, boost::_bi::value<impala::Promise<long>*> > >::operator()() (this=0x135107b8) at /home/dev/Impala/toolchain/boost-1.57.0/include/boost/bind/bind_template.hpp:20 #30 0x0000000001518f4c in boost::detail::thread_data<boost::_bi::bind_t<void, void (*)(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*), boost::_bi::list4<boost::_bi::value<std::string>, boost::_bi::value<std::string>, boost::_bi::value<boost::function<void ()> >, boost::_bi::value<impala::Promise<long>*> > > >::run() (this=0x13510600) at /home/dev/Impala/toolchain/boost-1.57.0/include/boost/thread/detail/thread.hpp:116 #31 0x000000000181305a in thread_proxy () #32 0x00007f5d3294f182 in start_thread (arg=0x7f5c78ab0700) at pthread_create.c:312 #33 0x00007f5d3037b47d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111