blob: e448d51f6bc305cdd024e7248ec7977065dae71e [file] [log] [blame]
set hive.vectorized.execution.enabled = true
;
explain
select
csmallint,
case
when csmallint = 418 then "a"
when csmallint = 12205 then "b"
else "c"
end,
case csmallint
when 418 then "a"
when 12205 then "b"
else "c"
end
from alltypesorc
where csmallint = 418
or csmallint = 12205
or csmallint = 10583
;
select
csmallint,
case
when csmallint = 418 then "a"
when csmallint = 12205 then "b"
else "c"
end,
case csmallint
when 418 then "a"
when 12205 then "b"
else "c"
end
from alltypesorc
where csmallint = 418
or csmallint = 12205
or csmallint = 10583
;