Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
Impala 2.3.0
-
None
-
Randomly generated data, I can provide access to the machine that has it loaded.
Description
Query:
SELECT COALESCE(LEAST(COALESCE(COALESCE(t914.pos, t914.pos, t927.int_col_t925), 657), COALESCE(SUM(t927.int_col_t926), -932)), COALESCE(t914.pos, t914.pos, t927.int_col_t925), COALESCE(t914.pos, t914.pos, t927.int_col_t925)) AS int_col, COALESCE(t914.pos, t914.pos, t927.int_col_t925) AS int_col_t928, LEAST(COALESCE(LAG(-398, 84) OVER (PARTITION BY IF(False, COALESCE(COALESCE(t914.pos, t914.pos, t927.int_col_t925), SUM(t927.int_col_t926), COALESCE(t914.pos, t914.pos, t927.int_col_t925)), COALESCE(t914.pos, t914.pos, t927.int_col_t925)) ORDER BY IF(False, COALESCE(COALESCE(t914.pos, t914.pos, t927.int_col_t925), SUM(t927.int_col_t926), COALESCE(t914.pos, t914.pos, t927.int_col_t925)), COALESCE(t914.pos, t914.pos, t927.int_col_t925)), COALESCE(t914.pos, t914.pos, t927.int_col_t925) DESC), -244), 671) AS int_col_t929, IF(False, COALESCE(COALESCE(t914.pos, t914.pos, t927.int_col_t925), SUM(t927.int_col_t926), COALESCE(t914.pos, t914.pos, t927.int_col_t925)), COALESCE(t914.pos, t914.pos, t927.int_col_t925)) AS int_col_t930 FROM table_2 t913 INNER JOIN t913.field_45 t914 ON (t914.pos) = (t913.field_55) INNER JOIN ( SELECT t916.pos AS int_col, GREATEST(COALESCE(t916.pos, -294), COALESCE(COUNT(t915.pos), -846)) AS int_col_t925, t915.pos AS int_col_t926 FROM t913.field_46 t915 INNER JOIN t913.field_45 t916 ON (t916.pos) = (t915.pos) LEFT JOIN t913.field_46 t917 ON (t917.pos) = (t916.pos) INNER JOIN ( SELECT COALESCE(t921.pos, t921.pos, t918.pos) AS int_col, LAG(-237, 45) OVER (ORDER BY COALESCE(t921.pos, t921.pos, t918.pos) ASC) AS int_col_t922, COALESCE(COALESCE(LAG(785) OVER (ORDER BY COALESCE(t921.pos, t921.pos, t918.pos) ASC), -741, 816), -879, 370) AS int_col_t923 FROM t914.item t918 INNER JOIN t914.item t919 ON (((t919.pos) = (t918.pos)) AND ((t919.pos) = (t918.pos))) AND ((t919.pos) = (t918.item)) INNER JOIN t913.field_46 t920 ON (((t920.pos) = (t918.pos)) AND ((t920.pos) = (t918.pos))) AND ((t920.pos) = (t918.pos)) INNER JOIN t914.item t921 ON (((t921.pos) = (t920.pos)) AND ((t921.pos) = (t920.pos))) AND ((t921.pos) = (t920.pos)) ) t924 ON ((t924.int_col_t923) = (t917.pos)) AND ((t924.int_col_t922) = (t917.pos)) WHERE (t924.int_col_t922) IN (t917.pos, t924.int_col) GROUP BY t916.pos, t915.pos ) t927 GROUP BY COALESCE(t914.pos, t914.pos, t927.int_col_t925) HAVING (COALESCE(MAX(COALESCE(t914.pos, t914.pos, t927.int_col_t925)), COALESCE(t914.pos, t914.pos, t927.int_col_t925), COALESCE(t914.pos, t914.pos, t927.int_col_t925))) IN (COALESCE(t914.pos, t914.pos, t927.int_col_t925), COALESCE(t914.pos, t914.pos, t927.int_col_t925))
Stack Trace:
#0 0x00007f8f80056cc9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #1 0x00007f8f8005a218 in __GI_abort () at abort.c:118 #2 0x00007f8f8004fb86 in __assert_fail_base (fmt=0x7f8f801a0830 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x2289a24 "px != 0", file=file@entry=0x22899f8 "/usr/include/boost/smart_ptr/scoped_ptr.hpp", line=line@entry=99, function=function@entry=0x228a820 <boost::scoped_ptr<impala::RowBatch>::operator->() const::__PRETTY_FUNCTION__> "T* boost::scoped_ptr<T>::operator->() const [with T = impala::RowBatch]") at assert.c:92 #3 0x00007f8f8004fc32 in __GI___assert_fail (assertion=0x2289a24 "px != 0", file=0x22899f8 "/usr/include/boost/smart_ptr/scoped_ptr.hpp", line=99, function=0x228a820 <boost::scoped_ptr<impala::RowBatch>::operator->() const::__PRETTY_FUNCTION__> "T* boost::scoped_ptr<T>::operator->() const [with T = impala::RowBatch]") at assert.c:101 #4 0x000000000159c0c5 in boost::scoped_ptr<impala::RowBatch>::operator-> (this=0xfbd91c0) at /usr/include/boost/smart_ptr/scoped_ptr.hpp:99 #5 0x00000000016cd09a in impala::SelectNode::Reset (this=0xfbd9080, state=0xfc3cd00) at /home/dev/Impala/be/src/exec/select-node.cc:114 #6 0x00000000015d221a in impala::ExecNode::Reset (this=0xd67f400, state=0xfc3cd00) at /home/dev/Impala/be/src/exec/exec-node.cc:166 #7 0x00000000016afa82 in impala::PartitionedHashJoinNode::Reset (this=0xd67f400, state=0xfc3cd00) at /home/dev/Impala/be/src/exec/partitioned-hash-join-node.cc:206 #8 0x00000000015d221a in impala::ExecNode::Reset (this=0xbef3800, state=0xfc3cd00) at /home/dev/Impala/be/src/exec/exec-node.cc:166 #9 0x000000000169bf09 in impala::PartitionedAggregationNode::Reset (this=0xbef3800, state=0xfc3cd00) at /home/dev/Impala/be/src/exec/partitioned-aggregation-node.cc:396 #10 0x00000000015d221a in impala::ExecNode::Reset (this=0xd6d5b80, state=0xfc3cd00) at /home/dev/Impala/be/src/exec/exec-node.cc:166 #11 0x0000000001690c28 in impala::NestedLoopJoinNode::Reset (this=0xd6d5b80, state=0xfc3cd00) at /home/dev/Impala/be/src/exec/nested-loop-join-node.cc:97 #12 0x00000000015d221a in impala::ExecNode::Reset (this=0xfbd91e0, state=0xfc3cd00) at /home/dev/Impala/be/src/exec/exec-node.cc:166 #13 0x00000000016d067d in impala::SubplanNode::Reset (this=0xfbd91e0, state=0xfc3cd00) at /home/dev/Impala/be/src/exec/subplan-node.cc:136 #14 0x00000000016cffc8 in impala::SubplanNode::GetNext (this=0xeb45600, state=0xfc3cd00, row_batch=0x7f8ec7114f40, eos=0x7f8ec7114e8e) at /home/dev/Impala/be/src/exec/subplan-node.cc:81 #15 0x000000000169abf6 in impala::PartitionedAggregationNode::Open (this=0xbef2c00, state=0xfc3cd00) at /home/dev/Impala/be/src/exec/partitioned-aggregation-node.cc:240 #16 0x0000000001598729 in impala::PlanFragmentExecutor::OpenInternal (this=0xceddd28) at /home/dev/Impala/be/src/runtime/plan-fragment-executor.cc:334 #17 0x000000000159852e in impala::PlanFragmentExecutor::Open (this=0xceddd28) at /home/dev/Impala/be/src/runtime/plan-fragment-executor.cc:320 #18 0x000000000137da8c in impala::FragmentMgr::FragmentExecState::Exec (this=0xceddb00) at /home/dev/Impala/be/src/service/fragment-exec-state.cc:50 #19 0x00000000013765cb in impala::FragmentMgr::FragmentExecThread (this=0xc223ec0, exec_state=0xceddb00) at /home/dev/Impala/be/src/service/fragment-mgr.cc:70 #20 0x0000000001379dd6 in boost::_mfi::mf1<void, impala::FragmentMgr, impala::FragmentMgr::FragmentExecState*>::operator() (this=0x10a88840, p=0xc223ec0, a1=0xceddb00) at /usr/include/boost/bind/mem_fn_template.hpp:165 #21 0x0000000001379b99 in boost::_bi::list2<boost::_bi::value<impala::FragmentMgr*>, boost::_bi::value<impala::FragmentMgr::FragmentExecState*> >::operator()<boost::_mfi::mf1<void, impala::FragmentMgr, impala::FragmentMgr::FragmentExecState*>, boost::_bi::list0> (this=0x10a88850, f=..., a=...) at /usr/include/boost/bind/bind.hpp:313 #22 0x00000000013794b3 in boost::_bi::bind_t<void, boost::_mfi::mf1<void, impala::FragmentMgr, impala::FragmentMgr::FragmentExecState*>, boost::_bi::list2<boost::_bi::value<impala::FragmentMgr*>, boost::_bi::value<impala::FragmentMgr::FragmentExecState*> > >::operator() (this=0x10a88840) at /usr/include/boost/bind/bind_template.hpp:20 #23 0x0000000001378e08 in boost::detail::function::void_function_obj_invoker0<boost::_bi::bind_t<void, boost::_mfi::mf1<void, impala::FragmentMgr, impala::FragmentMgr::FragmentExecState*>, boost::_bi::list2<boost::_bi::value<impala::FragmentMgr*>, boost::_bi::value<impala::FragmentMgr::FragmentExecState*> > >, void>::invoke (function_obj_ptr=...) at /usr/include/boost/function/function_template.hpp:153 #24 0x0000000001247b28 in boost::function0<void>::operator() (this=0x7f8ec7115e00) at /usr/include/boost/function/function_template.hpp:767 #25 0x0000000001457d5b in impala::Thread::SuperviseThread(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*) (name=..., category=..., functor=..., thread_started=0x7f8ecc21eea0) at /home/dev/Impala/be/src/util/thread.cc:314 #26 0x0000000001460f91 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=0xfb785c0, f=@0xfb785b8: 0x1457a52 <impala::Thread::SuperviseThread(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*)>, a=...) at /usr/include/boost/bind/bind.hpp:457 #27 0x0000000001460edb 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=0xfb785b8) at /usr/include/boost/bind/bind_template.hpp:20 #28 0x0000000001460ea0 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=0xfb78400) at /usr/include/boost/thread/detail/thread.hpp:117 #29 0x00007f8f83020a4a in ?? () from /usr/lib/x86_64-linux-gnu/libboost_thread.so.1.54.0 #30 0x00007f8f824cd182 in start_thread (arg=0x7f8ec7116700) at pthread_create.c:312 #31 0x00007f8f8011a47d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111