[IMPALA-735] select with distinct and full outer join, impalad coredump

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 1.2.1
• Fix Version/s: Impala 1.2.4
• Environment: OS: CentOS release 6.3 ; CPU: Intel Xeon(R) CPU E5-2620 2.0GHz; Memory: 48GB
• Assignee: Nong Li
• Reporter: qiushanggao
• Created: 09/Jan/14 01:43
• Updated: 20/Dec/15 00:05
• Resolved: 07/Feb/14 22:56

Description

in shell, input thoses command:
create table tttt(c1 int, c2 string, c3 timestamp);
create table t1(n1 int, n2 string);

insert into tttt values(1,'qiushanggao','2014-01-01');
insert into t1 values(1,'jushan');

select distinct t1.* from t1 full outer join tttt on c2=n2;

impald coredump, I find the callstack in hs_err_pidxxx.log file:
Stack: [0x00007fd02e461000,0x00007fd02ee62000], sp=0x00007fd02ee5f8c0, free space=10234k Native frames: (J=compiled Java code, j=interpreted, Vv=VM code, C=native code) C 0x00007fd0333697ad
C [ssqld+0xcae716] impala::PlanFragmentExecutor::OpenInternal()+0x92
C [ssqld+0xcae592] impala::PlanFragmentExecutor::Open()+0x38a
C [ssqld+0x96b217] impala::ImpalaServer::FragmentExecState::Exec()+0x23
C [ssqld+0x97fa46] impala::ImpalaServer::RunExecPlanFragment(impala::ImpalaServer::FragmentExecState*)+0x4c
C [ssqld+0x9f41ec] boost::_mfi::mf1<void, impala::ImpalaServer, impala::ImpalaServer::FragmentExecState*>::operator()(impala::ImpalaServer*, impala::ImpalaServer::FragmentExecState*) const+0x64
C [ssqld+0x9f246d] void boost::_bi::list2<boost::_bi::value<impala::ImpalaServer*>, boost::_bi::value<impala::ImpalaServer::FragmentExecState*> >::operator()<boost::_mfi::mf1<void, impala::ImpalaServer, impala::ImpalaServer::FragmentExecState*>, boost::_bi::list0>(boost::_bi::type<void>, boost::_mfi::mf1<void, impala::ImpalaServer, impala::ImpalaServer::FragmentExecState*>&, boost::_bi::list0&, int)+0x69

if use this command "select distinct t1.* from t1 full outer join tttt on c1=n1", the result is right.