Details
-
Bug
-
Status: Resolved
-
Blocker
-
Resolution: Fixed
-
Impala 2.3.0
-
None
-
Randomly generated data
Description
Query:
SELECT (t1094.field_73) IN (t1094.field_59.field_66, t1093.int_col_t1092) AS boolean_col, COALESCE(t1086.field_73, t1094.field_71, t1093.int_col) AS int_col FROM table_3 t1086 INNER JOIN ( SELECT (COUNT(t1090.int_col)) - (COALESCE(-950, -501, 138)) AS int_col, IF(True, COUNT(26.95), -962) AS int_col_t1092 FROM t1086.field_74 t1087 INNER JOIN t1086.field_74 t1088 ON (((t1088.pos) = (t1087.pos)) AND ((t1088.pos) = (t1087.pos))) AND ((t1088.pos) = (t1087.pos)) LEFT JOIN ( SELECT 398 AS int_col FROM t1086.field_58 t1089 WHERE (778) IN (836, 380) ) t1090 ON (t1090.int_col) = (t1088.pos) LEFT JOIN t1086.field_74 t1091 ON (t1091.pos) = (t1087.pos) ) t1093 INNER JOIN table_3 t1094 ON (((t1094.field_57) = (t1086.field_59.field_69)) AND ((t1094.field_57) = (t1086.field_59.field_69))) AND ((t1094.field_59.field_69) = (t1086.field_57))
Stack Trace:
#0 0x00007f0766dabcc9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #1 0x00007f0766daf0d8 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=0x7f06f57dce20) at src/logging.cc:1269 #5 0x00000000021117e3 in google::LogMessage::Flush (this=this@entry=0x7f06f57dce20) at src/logging.cc:1138 #6 0x000000000211446e in google::LogMessageFatal::~LogMessageFatal (this=0x7f06f57dce20, __in_chrg=<optimized out>) at src/logging.cc:1836 #7 0x0000000001569a75 in impala::Coordinator::ValidateCollectionSlots (this=0xc1d7100, batch=0xb5f1e00) at /home/dev/Impala/be/src/runtime/coordinator.cc:908 #8 0x00000000015697c9 in impala::Coordinator::GetNext (this=0xc1d7100, batch=0x80cbb88, state=0xc208400) at /home/dev/Impala/be/src/runtime/coordinator.cc:888 #9 0x000000000135c329 in impala::ImpalaServer::QueryExecState::FetchNextBatch (this=0x80ca000) at /home/dev/Impala/be/src/service/query-exec-state.cc:870 #10 0x000000000135a3d9 in impala::ImpalaServer::QueryExecState::FetchRowsInternal (this=0x80ca000, max_rows=1024, fetched_rows=0x7f06f57dd370) at /home/dev/Impala/be/src/service/query-exec-state.cc:699 #11 0x0000000001359a7d in impala::ImpalaServer::QueryExecState::FetchRows (this=0x80ca000, max_rows=1024, fetched_rows=0x7f06f57dd370) at /home/dev/Impala/be/src/service/query-exec-state.cc:609 #12 0x000000000134f83a in impala::ImpalaServer::FetchInternal (this=0x306c680, query_id=..., start_over=false, fetch_size=1024, query_results=0x7f06f57dd668) at /home/dev/Impala/be/src/service/impala-beeswax-server.cc:613 #13 0x000000000134b156 in impala::ImpalaServer::fetch (this=0x306c680, query_results=..., query_handle=..., start_over=false, fetch_size=1024) at /home/dev/Impala/be/src/service/impala-beeswax-server.cc:288 #14 0x00000000014e7f34 in beeswax::BeeswaxServiceProcessor::process_fetch (this=0xc37c000, seqid=0, iprot=0xb849200, oprot=0xbf54b40, callContext=0xb44ff00) at /home/dev/Impala/be/generated-sources/gen-cpp/BeeswaxService.cpp:3150 #15 0x00000000014e6372 in beeswax::BeeswaxServiceProcessor::dispatchCall (this=0xc37c000, iprot=0xb849200, oprot=0xbf54b40, fname=..., seqid=0, callContext=0xb44ff00) at /home/dev/Impala/be/generated-sources/gen-cpp/BeeswaxService.cpp:2952 #16 0x00000000014cf7db in impala::ImpalaServiceProcessor::dispatchCall (this=0xc37c000, iprot=0xb849200, oprot=0xbf54b40, fname=..., seqid=0, callContext=0xb44ff00) at /home/dev/Impala/be/generated-sources/gen-cpp/ImpalaService.cpp:1673 #17 0x00000000012e6865 in apache::thrift::TDispatchProcessor::process (this=0xc37c000, in=..., out=..., connectionContext=0xb44ff00) at /home/dev/Impala/thirdparty/thrift-0.9.0/build/include/thrift/TDispatchProcessor.h:121 #18 0x00000000020b78ba in apache::thrift::server::TThreadPoolServer::Task::run (this=0xb62d860) at src/thrift/server/TThreadPoolServer.cpp:70 #19 0x00000000020a3fff in apache::thrift::concurrency::ThreadManager::Task::run (this=0xbf54b00) at src/thrift/concurrency/ThreadManager.cpp:187 #20 0x00000000020a6c6a in apache::thrift::concurrency::ThreadManager::Worker::run (this=0x7063770) at src/thrift/concurrency/ThreadManager.cpp:316 #21 0x0000000001211581 in impala::ThriftThread::RunRunnable (this=0xb44f180, runnable=..., promise=0x7fff240b08e0) at /home/dev/Impala/be/src/rpc/thrift-thread.cc:61 #22 0x0000000001212d49 in boost::_mfi::mf2<void, impala::ThriftThread, boost::shared_ptr<apache::thrift::concurrency::Runnable>, impala::Promise<unsigned long>*>::operator() (this=0x7067200, p=0xb44f180, a1=..., a2=0x7fff240b08e0) at /usr/include/boost/bind/mem_fn_template.hpp:280 #23 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=0x7067210, f=..., a=...) at /usr/include/boost/bind/bind.hpp:392 #24 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=0x7067200) at /usr/include/boost/bind/bind_template.hpp:20 #25 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 #26 0x0000000001247d70 in boost::function0<void>::operator() (this=0x7f06f57dde00) at /usr/include/boost/function/function_template.hpp:767 #27 0x00000000014582a9 in impala::Thread::SuperviseThread(std::string const&, std::string const&, boost::function<void ()>, impala::Promise<long>*) (name=..., category=..., functor=..., thread_started=0x7fff240b0720) at /home/dev/Impala/be/src/util/thread.cc:314 #28 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=0xb44c1c0, f=@0xb44c1b8: 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 #29 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=0xb44c1b8) at /usr/include/boost/bind/bind_template.hpp:20 #30 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=0xb44c000) at /usr/include/boost/thread/detail/thread.hpp:117 #31 0x00007f0769d75a4a in ?? () from /usr/lib/x86_64-linux-gnu/libboost_thread.so.1.54.0 #32 0x00007f0769222182 in start_thread (arg=0x7f06f57de700) at pthread_create.c:312 #33 0x00007f0766e6f47d 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)