Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
Impala 2.3.0
-
None
-
Randomly generated data, I can give access to the machine that has it loaded.
Description
SELECT (FIRST_VALUE(LEAST(977, 480)) OVER (PARTITION BY COALESCE(t28.pos, t28.pos, t28.pos) ORDER BY COALESCE(t28.pos, t28.pos, t28.pos) DESC, (MAX(t34.int_col)) + (MIN(t27.field_55)) DESC)) / (179.417146203) AS float_col, (MAX(t34.int_col)) + (MIN(t27.field_55)) AS int_col, COALESCE(t28.pos, t28.pos, t28.pos) AS int_col_t35, (t28.pos) * (t28.pos) AS int_col_t36 FROM table_2 t27 INNER JOIN t27.field_46 t28 ON (((t28.pos) = (t27.field_55)) AND ((t28.pos) = (t27.field_55))) AND ((t28.pos) = (t27.field_55)) INNER JOIN ( SELECT COALESCE(LAST_VALUE(608) OVER (ORDER BY GREATEST(COALESCE(t30.value.field_48, 520), COALESCE(t31.pos, 295)) DESC, CAST(t31.pos AS STRING)), LAG(2, 63) OVER (ORDER BY GREATEST(COALESCE(t30.value.field_48, 520), COALESCE(t31.pos, 295)) DESC, CAST(t31.pos AS STRING)), 933) AS int_col, GREATEST(COALESCE(t30.value.field_48, 520), COALESCE(t31.pos, 295)) AS int_col_t32, CAST(t31.pos AS STRING) AS char_col, COALESCE(129, 30, LAG(464) OVER (ORDER BY GREATEST(COALESCE(t30.value.field_48, 520), COALESCE(t31.pos, 295)), CAST(t31.pos AS STRING))) AS int_col_t33 FROM t27.field_45 t29 INNER JOIN t28.item t30 ON (((t30.value.field_51) = (t29.pos)) AND ((t30.value.field_48) = (t29.pos))) AND ((t30.value.field_51) = (t29.pos)) LEFT JOIN t29.item t31 ) t34 ON (t34.int_col_t33) = (t28.pos) WHERE (t34.int_col) NOT IN (t34.int_col_t32, t28.pos) GROUP BY COALESCE(t28.pos, t28.pos, t28.pos), (t28.pos) * (t28.pos) HAVING ((t28.pos) * (t28.pos)) NOT IN (MAX(t27.field_55), COALESCE(t28.pos, t28.pos, t28.pos))
Stack Trace:
#0 0x00007f6b46cd0cc9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #1 0x00007f6b46cd4218 in __GI_abort () at abort.c:118 #2 0x00007f6b46cc9b86 in __assert_fail_base (fmt=0x7f6b46e1a830 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x22b5bec "px != 0", file=file@entry=0x22b5bc0 "/usr/include/boost/smart_ptr/scoped_ptr.hpp", line=line@entry=99, function=function@entry=0x22b60a0 <boost::scoped_ptr<impala::BufferedTupleStream>::operator->() const::__PRETTY_FUNCTION__> "T* boost::scoped_ptr<T>::operator->() const [with T = impala::BufferedTupleStream]") at assert.c:92 #3 0x00007f6b46cc9c32 in __GI___assert_fail (assertion=0x22b5bec "px != 0", file=0x22b5bc0 "/usr/include/boost/smart_ptr/scoped_ptr.hpp", line=99, function=0x22b60a0 <boost::scoped_ptr<impala::BufferedTupleStream>::operator->() const::__PRETTY_FUNCTION__> "T* boost::scoped_ptr<T>::operator->() const [with T = impala::BufferedTupleStream]") at assert.c:101 #4 0x00000000016a68f3 in boost::scoped_ptr<impala::BufferedTupleStream>::operator-> (this=0x10af8a10) at /usr/include/boost/smart_ptr/scoped_ptr.hpp:99 #5 0x00000000016ea4e0 in impala::AnalyticEvalNode::Reset (this=0x10af8700, state=0x9592900) at /home/dev/Impala/be/src/exec/analytic-eval-node.cc:778 #6 0x00000000015d221a in impala::ExecNode::Reset (this=0xe4f3680, state=0x9592900) at /home/dev/Impala/be/src/exec/exec-node.cc:166 #7 0x0000000001690c28 in impala::NestedLoopJoinNode::Reset (this=0xe4f3680, state=0x9592900) at /home/dev/Impala/be/src/exec/nested-loop-join-node.cc:97 #8 0x00000000015d221a in impala::ExecNode::Reset (this=0x105ee420, state=0x9592900) at /home/dev/Impala/be/src/exec/exec-node.cc:166 #9 0x00000000016d067d in impala::SubplanNode::Reset (this=0x105ee420, state=0x9592900) at /home/dev/Impala/be/src/exec/subplan-node.cc:136 #10 0x00000000016cffc8 in impala::SubplanNode::GetNext (this=0x105ee6e0, state=0x9592900, row_batch=0x7f6a8dd8ef40, eos=0x7f6a8dd8ee8e) at /home/dev/Impala/be/src/exec/subplan-node.cc:81 #11 0x000000000169abf6 in impala::PartitionedAggregationNode::Open (this=0xd190600, state=0x9592900) at /home/dev/Impala/be/src/exec/partitioned-aggregation-node.cc:240 #12 0x0000000001598729 in impala::PlanFragmentExecutor::OpenInternal (this=0xca37828) at /home/dev/Impala/be/src/runtime/plan-fragment-executor.cc:334 #13 0x000000000159852e in impala::PlanFragmentExecutor::Open (this=0xca37828) at /home/dev/Impala/be/src/runtime/plan-fragment-executor.cc:320 #14 0x000000000137da8c in impala::FragmentMgr::FragmentExecState::Exec (this=0xca37600) at /home/dev/Impala/be/src/service/fragment-exec-state.cc:50 #15 0x00000000013765cb in impala::FragmentMgr::FragmentExecThread (this=0xcef6d20, exec_state=0xca37600) at /home/dev/Impala/be/src/service/fragment-mgr.cc:70 #16 0x0000000001379dd6 in boost::_mfi::mf1<void, impala::FragmentMgr, impala::FragmentMgr::FragmentExecState*>::operator() (this=0x113bec40, p=0xcef6d20, a1=0xca37600) at /usr/include/boost/bind/mem_fn_template.hpp:165 #17 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=0x113bec50, f=..., a=...) at /usr/include/boost/bind/bind.hpp:313 #18 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=0x113bec40) at /usr/include/boost/bind/bind_template.hpp:20 #19 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 #20 0x0000000001247b28 in boost::function0<void>::operator() (this=0x7f6a8dd8fe00) at /usr/include/boost/function/function_template.hpp:767 #21 0x0000000001457d5b in impala::Thread::SuperviseThread(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*) (name=..., category=..., functor=..., thread_started=0x7f6a92e98ea0) at /home/dev/Impala/be/src/util/thread.cc:314 #22 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=0x1097cbc0, f=@0x1097cbb8: 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 #23 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=0x1097cbb8) at /usr/include/boost/bind/bind_template.hpp:20 #24 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=0x1097ca00) at /usr/include/boost/thread/detail/thread.hpp:117 #25 0x00007f6b49c9aa4a in ?? () from /usr/lib/x86_64-linux-gnu/libboost_thread.so.1.54.0 #26 0x00007f6b49147182 in start_thread (arg=0x7f6a8dd90700) at pthread_create.c:312 #27 0x00007f6b46d9447d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111