[IMPALA-1434] SQL (contain group by case ifnull(cky2,oprator) ) cause impalad crash

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.1
• Fix Version/s: Impala 2.2
• Component/s: Clients
• Labels: impala shell
• Environment: centos 6.3 32G
• Assignee: Skye Wanderman-Milne
• Reporter: fishing
• Created: 30/Oct/14 11:32
• Updated: 14/Jan/16 03:56
• Resolved: 26/Nov/14 02:15

Description

when I use boot parameter -v=2 startup impalad , this query cause impalad dead ::

select 35 as type,
case ifnull(cky2,oprator)
when 6 then 1 else 9786
end as operators,count(1) as num1,0 as num2
from orders
where createdate>=DATE_ADD(CURDATE(),INTERVAL -1 DAY)
and createdate < CURDATE() and splittype != 2 and jyn not in (4,8,18,33)
group by
case ifnull(cky2,oprator)
when 6 then 1 else 9786
end

I use gdb trace ， found dead in file“plan-fragment-executor.cc” prepare method call
VLOG(2) << "plan_root=\n" << plan_->DebugString();