case-when语句

ekqde3dh 于 2021-06-25 发布在 Hive

关注(0)|答案(2)|浏览(499)

我的问题：

case 
   when upper(a.camp_name) like "%Event%" and (upper(a.camp_name) not like "%Event-WBR%" or upper(a.camp_name) not like "%Event-Webinar%") THEN "Field"
   else "Demand"
end as Tactic

期望输出：

Event-WBR = Demand
Event = Field

实际输出：

Event-WBR = Field
Event = Field

sql Hive hiveql hive-query case-statement

来源：https://stackoverflow.com/questions/61241028/hive-sql-logic-case-when-statement

2条答案

按热度按时间

fjaof16o1#

你可以用两个 when 学生：

(case when (upper(a.camp_name) not like "%Event-WBR%" or 
            upper(a.camp_name) not like "%Event-Webinar%"
           ) then 'Event'
      when upper(a.camp_name) like "%Event%" then 'Event'
      else 'Deman'
 end) as tactic

赞(0）回复(0）举报 2021-06-26

v1uwarro2#

实际上你应该用and替换or

case 
       when upper(a.camp_name) like "%Event%" and (upper(a.camp_name) not like "%Event-WBR%" and upper(a.camp_name) not like "%Event-Webinar%") THEN "Demand"
       else "Field"
    end as Tactic

但这里还有另外两个选择：
如果你只想做“事件”这个词，你可以这样做

case 
   when upper(a.camp_name) like "%Event" and (upper(a.camp_name) not like "%Event-WBR%" or upper(a.camp_name) not like "%Event-Webinar%") THEN "Demand"
   else "Field"
end as Tactic

如果你只想排除这两个词，你可以这样做。

case 
   when upper(a.camp_name) like "%Event-WBR%" or (upper(a.camp_name) like "%Event-Webinar%" THEN "Field"
   else "Demand"
end as Tactic

赞(0）回复(0）举报 2021-06-26

我来回答

case-when语句

我的问题：

2条答案

相关问题

热门标签

最新问答