Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Duplicate
-
Impala 2.3.0
-
None
-
None
Description
Query:
use random_nested_db_0; SELECT COALESCE(LEAD(COALESCE(-948, -836), 43) OVER (ORDER BY COALESCE(t9.int_col_t4, t10.field_10.field_13, t11.field_16) DESC), LAG(202, 59) OVER (ORDER BY COALESCE(t9.int_col_t4, t10.field_10.field_13, t11.field_16)), COALESCE(479, NULL, 651)) AS int_col, COALESCE(t9.int_col_t4, t10.field_10.field_13, t11.field_16) AS int_col_t12 FROM ( SELECT DISTINCT COALESCE(t1.pos, t2.value, t1.pos) AS int_col, COALESCE(t2.value, t1.pos, t1.pos) AS int_col_t4 FROM table_3.field_88.value t1 LEFT JOIN table_3.field_90.field_92.value t2 ON ((t2.value) = (t1.pos)) AND ((t2.value) = (t1.pos)) LEFT JOIN t1.item t3 UNION ALL SELECT (673.207169409) / (t5.pos) AS float_col, ABS(836.211809943) AS float_col_t6 FROM table_1.field_19.value t5 UNION ALL SELECT LAG(((-371.351014454) / (761)) * (-604), 45) OVER (ORDER BY t8.pos DESC, t7.pos) AS float_col, COALESCE(-940, -382, COALESCE(LEAST(COALESCE(LAG(821, 77) OVER (ORDER BY t8.item ASC, t8.pos DESC), 497), -903), 986)) AS int_col FROM table_3.field_88.value t7 LEFT JOIN table_1.field_19.value.item.field_21.item t8 ON ((t8.pos) = (t7.pos)) AND ((t8.pos) = (t7.pos)) WHERE (t8.pos) = (t7.pos) ) t9 LEFT JOIN table_0 t10 ON ((t10.field_10.field_13) = (t9.int_col_t4)) AND ((t10.field_5) = (t9.int_col)) INNER JOIN table_0 t11 ON ((t11.field_16) = (t9.int_col_t4)) AND ((t11.field_5) = (t9.int_col_t4))
Stack Trace:
#0 0x00007fc539d95cc9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #1 0x00007fc539d990d8 in __GI_abort () at abort.c:89 #2 0x00007fc53b9a89c5 in os::abort(bool) () from /usr/lib/jvm/java-7-oracle/jre/lib/amd64/server/libjvm.so #3 0x00007fc53bb29607 in VMError::report_and_die() () from /usr/lib/jvm/java-7-oracle/jre/lib/amd64/server/libjvm.so #4 0x00007fc53b9ad8af in JVM_handle_linux_signal () from /usr/lib/jvm/java-7-oracle/jre/lib/amd64/server/libjvm.so #5 <signal handler called> #6 0x00000000016cf380 in impala::BufferedTupleStream::rows_returned (this=0x0) at /home/dev/Impala/be/src/runtime/buffered-tuple-stream.h:234 #7 0x00000000016fc1e2 in impala::AnalyticEvalNode::GetNext (this=0xe63a700, state=0xcb7cd00, row_batch=0x7fc480e9bd10, eos=0x7fc480e9bcff) at /home/dev/Impala/be/src/exec/analytic-eval-node.cc:752 #8 0x00000000016e0e73 in impala::SortNode::SortInput (this=0xf04bc00, state=0xcb7cd00) at /home/dev/Impala/be/src/exec/sort-node.cc:155 #9 0x00000000016e034c in impala::SortNode::Open (this=0xf04bc00, state=0xcb7cd00) at /home/dev/Impala/be/src/exec/sort-node.cc:76 #10 0x00000000016f8740 in impala::AnalyticEvalNode::Open (this=0xe63a380, state=0xcb7cd00) at /home/dev/Impala/be/src/exec/analytic-eval-node.cc:180 #11 0x000000000159d3a8 in impala::PlanFragmentExecutor::OpenInternal (this=0xcb7bd28) at /home/dev/Impala/be/src/runtime/plan-fragment-executor.cc:334 #12 0x000000000159d1a8 in impala::PlanFragmentExecutor::Open (this=0xcb7bd28) at /home/dev/Impala/be/src/runtime/plan-fragment-executor.cc:320 #13 0x00000000013814fc in impala::FragmentMgr::FragmentExecState::Exec (this=0xcb7bb00) at /home/dev/Impala/be/src/service/fragment-exec-state.cc:50 #14 0x000000000137a03b in impala::FragmentMgr::FragmentExecThread (this=0xda61020, exec_state=0xcb7bb00) at /home/dev/Impala/be/src/service/fragment-mgr.cc:83 #15 0x000000000137d846 in boost::_mfi::mf1<void, impala::FragmentMgr, impala::FragmentMgr::FragmentExecState*>::operator() (this=0xe6322c0, p=0xda61020, a1=0xcb7bb00) at /usr/include/boost/bind/mem_fn_template.hpp:165 #16 0x000000000137d609 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=0xe6322d0, f=..., a=...) at /usr/include/boost/bind/bind.hpp:313 #17 0x000000000137cf23 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=0xe6322c0) at /usr/include/boost/bind/bind_template.hpp:20 #18 0x000000000137c878 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 #19 0x000000000124a744 in boost::function0<void>::operator() (this=0x7fc480e9ce00) at /usr/include/boost/function/function_template.hpp:767 #20 0x000000000145ba8d in impala::Thread::SuperviseThread(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*) (name=..., category=..., functor=..., thread_started=0x7fc485f25dd0) at /home/dev/Impala/be/src/util/thread.cc:314 #21 0x0000000001464cc3 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=0xf04b3c0, f=@0xf04b3b8: 0x145b784 <impala::Thread::SuperviseThread(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*)>, a=...) at /usr/include/boost/bind/bind.hpp:457 #22 0x0000000001464c0d 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=0xf04b3b8) at /usr/include/boost/bind/bind_template.hpp:20 #23 0x0000000001464bd2 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=0xf04b200) at /usr/include/boost/thread/detail/thread.hpp:117 #24 0x00007fc53cd5fa4a in ?? () from /usr/lib/x86_64-linux-gnu/libboost_thread.so.1.54.0 #25 0x00007fc53c20c182 in start_thread (arg=0x7fc480e9d700) at pthread_create.c:312 #26 0x00007fc539e5947d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
To access the machine with loaded data:
ssh vd0206.halxg.cloudera.com ssh dev@192.168.123.64 # pw = cloudera cd Impala # proceed as usual