Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Duplicate
-
Impala 2.3.0
-
None
-
None
Description
Query:
SELECT COALESCE(t210.field_75, t222.int_col_t220, t212.field_0.field_9) AS int_col FROM table_4 t210 INNER JOIN t210.field_76 t211 INNER JOIN table_0 t212 ON (((t212.field_0.field_3) = (t210.field_75)) AND ((t212.field_0.field_3) = (t210.field_75))) AND ((t212.field_0.field_4) = (t210.field_75)) INNER JOIN ( WITH with_1 AS (SELECT (MAX(t214.value)) + (-591) AS int_col, GREATEST(COALESCE(IF(True, 709, LAG(-846, 75) OVER (PARTITION BY (MAX(t214.value)) + (-591) ORDER BY (MAX(t214.value)) + (-591), COALESCE(626, MIN((t214.value) - (t214.value))) DESC)), -772), 977) AS int_col_t215, COALESCE(626, MIN((t214.value) - (t214.value))) AS int_col_t216 FROM t212.field_12 t213 INNER JOIN t213.item t214 ON (t214.value) = (t213.pos)) SELECT COALESCE(t217.pos, t218.pos, t219.pos) AS int_col, COALESCE(t219.pos, t219.pos, MAX(t219.pos)) AS int_col_t220, t219.pos AS int_col_t221 FROM t212.field_0.field_5 t217 INNER JOIN t212.field_0.field_5 t218 ON (((t218.pos) = (t217.pos)) AND ((t218.pos) = (t217.pos))) AND ((t218.pos) = (t217.pos)) INNER JOIN t212.field_12 t219 ON (((t219.pos) = (t218.pos)) AND ((t219.pos) = (t218.pos))) AND ((t219.pos) = (t218.pos)) WHERE (NULL) > (539.6) GROUP BY COALESCE(t217.pos, t218.pos, t219.pos), t219.pos ) t222 WHERE (t222.int_col_t221) != (t222.int_col)
Stack Trace:
#0 0x00007f046ce5ecc9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #1 0x00007f046ce620d8 in __GI_abort () at abort.c:89 #2 0x0000000002118bd9 in google::DumpStackTraceAndExit () at src/utilities.cc:147 #3 0x0000000002111c8d in google::LogMessage::Fail () at src/logging.cc:1315 #4 0x0000000002113b15 in google::LogMessage::SendToLog (this=0x7f03b980ac40) at src/logging.cc:1269 #5 0x00000000021117e3 in google::LogMessage::Flush (this=this@entry=0x7f03b980ac40) at src/logging.cc:1138 #6 0x000000000211446e in google::LogMessageFatal::~LogMessageFatal (this=0x7f03b980ac40, __in_chrg=<optimized out>) at src/logging.cc:1836 #7 0x00000000012165d9 in impala::RowDescriptor::GetTupleIdx (this=0xd2d8448, id=2) at /home/dev/Impala/be/src/runtime/descriptors.cc:401 #8 0x0000000000fff706 in impala::SlotRef::Prepare (this=0xcf54960, state=0xcf5d200, row_desc=..., context=0xced3d40) at /home/dev/Impala/be/src/exprs/slot-ref.cc:82 #9 0x0000000000fccf68 in impala::ExprContext::Prepare (this=0xced3d40, state=0xcf5d200, row_desc=..., tracker=0xfc862c0) at /home/dev/Impala/be/src/exprs/expr-context.cc:53 #10 0x00000000016db107 in impala::UnnestNode::Prepare (this=0x8b66700, state=0xcf5d200) at /home/dev/Impala/be/src/exec/unnest-node.cc:71 #11 0x00000000015d241b in impala::ExecNode::Prepare (this=0xd612780, state=0xcf5d200) at /home/dev/Impala/be/src/exec/exec-node.cc:153 #12 0x00000000016f2f15 in impala::BlockingJoinNode::Prepare (this=0xd612780, state=0xcf5d200) at /home/dev/Impala/be/src/exec/blocking-join-node.cc:62 #13 0x0000000001690e24 in impala::NestedLoopJoinNode::Prepare (this=0xd612780, state=0xcf5d200) at /home/dev/Impala/be/src/exec/nested-loop-join-node.cc:72 #14 0x00000000015d241b in impala::ExecNode::Prepare (this=0xd0af8c0, state=0xcf5d200) at /home/dev/Impala/be/src/exec/exec-node.cc:153 #15 0x00000000016d0044 in impala::SubplanNode::Prepare (this=0xd0af8c0, state=0xcf5d200) at /home/dev/Impala/be/src/exec/subplan-node.cc:58 #16 0x00000000015d241b in impala::ExecNode::Prepare (this=0xd603c00, state=0xcf5d200) at /home/dev/Impala/be/src/exec/exec-node.cc:153 #17 0x00000000016f2f15 in impala::BlockingJoinNode::Prepare (this=0xd603c00, state=0xcf5d200) at /home/dev/Impala/be/src/exec/blocking-join-node.cc:62 #18 0x00000000016ae79b in impala::PartitionedHashJoinNode::Prepare (this=0xd603c00, state=0xcf5d200) at /home/dev/Impala/be/src/exec/partitioned-hash-join-node.cc:102 #19 0x000000000159702b in impala::PlanFragmentExecutor::Prepare (this=0xcf5c228, request=...) at /home/dev/Impala/be/src/runtime/plan-fragment-executor.cc:236 #20 0x000000000137df33 in impala::FragmentMgr::FragmentExecState::Prepare (this=0xcf5c000, exec_params=...) at /home/dev/Impala/be/src/service/fragment-exec-state.cc:44 #21 0x00000000013766b3 in impala::FragmentMgr::ExecPlanFragment (this=0x8d08d80, exec_params=...) at /home/dev/Impala/be/src/service/fragment-mgr.cc:51 #22 0x00000000012efcf1 in impala::ImpalaInternalService::ExecPlanFragment (this=0xe45b380, return_val=..., params=...) at /home/dev/Impala/be/src/service/impala-internal-service.h:37 #23 0x00000000014c68b5 in impala::ImpalaInternalServiceProcessor::process_ExecPlanFragment (this=0x8d08d20, seqid=0, iprot=0xe45fc80, oprot=0xe45fc40, callContext=0xcf482c0) at /home/dev/Impala/be/generated-sources/gen-cpp/ImpalaInternalService.cpp:949 #24 0x00000000014c65c6 in impala::ImpalaInternalServiceProcessor::dispatchCall (this=0x8d08d20, iprot=0xe45fc80, oprot=0xe45fc40, fname=..., seqid=0, callContext=0xcf482c0) at /home/dev/Impala/be/generated-sources/gen-cpp/ImpalaInternalService.cpp:922 #25 0x00000000012e6865 in apache::thrift::TDispatchProcessor::process (this=0x8d08d20, in=..., out=..., connectionContext=0xcf482c0) at /home/dev/Impala/thirdparty/thrift-0.9.0/build/include/thrift/TDispatchProcessor.h:121 #26 0x00000000020babb3 in apache::thrift::server::TThreadedServer::Task::run (this=0xcf460c0) at src/thrift/server/TThreadedServer.cpp:70 #27 0x0000000001211581 in impala::ThriftThread::RunRunnable (this=0xcf48200, runnable=..., promise=0x7f04100b9790) at /home/dev/Impala/be/src/rpc/thrift-thread.cc:61 #28 0x0000000001212d49 in boost::_mfi::mf2<void, impala::ThriftThread, boost::shared_ptr<apache::thrift::concurrency::Runnable>, impala::Promise<unsigned long>*>::operator() (this=0xcf44840, p=0xcf48200, a1=..., a2=0x7f04100b9790) at /usr/include/boost/bind/mem_fn_template.hpp:280 #29 0x0000000001212ba4 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=0xcf44850, f=..., a=...) at /usr/include/boost/bind/bind.hpp:392 #30 0x0000000001212935 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=0xcf44840) at /usr/include/boost/bind/bind_template.hpp:20 #31 0x0000000001212856 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 /usr/include/boost/function/function_template.hpp:153 #32 0x0000000001247d70 in boost::function0<void>::operator() (this=0x7f03b980ce00) at /usr/include/boost/function/function_template.hpp:767 #33 0x00000000014582a9 in impala::Thread::SuperviseThread(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*) (name=..., category=..., functor=..., thread_started=0x7f04100b95d0) at /home/dev/Impala/be/src/util/thread.cc:314 #34 0x00000000014614df 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=0xcf4a1c0, f=@0xcf4a1b8: 0x1457fa0 <impala::Thread::SuperviseThread(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*)>, a=...) at /usr/include/boost/bind/bind.hpp:457 #35 0x0000000001461429 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=0xcf4a1b8) at /usr/include/boost/bind/bind_template.hpp:20 #36 0x00000000014613ee 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=0xcf4a000) at /usr/include/boost/thread/detail/thread.hpp:117 #37 0x00007f046fe28a4a in ?? () from /usr/lib/x86_64-linux-gnu/libboost_thread.so.1.54.0 #38 0x00007f046f2d5182 in start_thread (arg=0x7f03b980d700) at pthread_create.c:312 #39 0x00007f046cf2247d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
To access the machine with the loaded data:
ssh dev@vd0206.halxg.cloudera.com -p 33334 (pw: cloudera) run-all.sh && start-impala-cluster.py impala-shell.sh use random_nested_db_0;
core dumps are saved to /tmp/core_files