CASE在雅典娜Presto上有多个值

Question

我正在寻求一些建议。

我有多个值，我希望编码到相同的输出，但雅典娜似乎不识别SQL。

CASE customer_name
WHEN 'Aa' or 'Ar' or 'Aar' or 'Aaro' THEN 'Aaron' END as customer_name

我想避免做以下事情:

CASE customer_name
WHEN 'Aa' THEN 'Aaron'
WHEN 'Ar' THEN 'Aaron'
WHEN 'Ar' THEN 'Aaron'
WHEN 'Ar' THEN 'Aaron'
END as customer_name

Answer 1

您可以将该字段移动到'WHEN'子句中:

WITH dataset ( customer_name) AS
(
VALUES
('Aa'),
('Ar'),
('Ar'),
('Ar'),
('B')
)
SELECT
CASE
WHEN customer_name IN ('Aa', 'Ar', 'Aar', 'Aaro') THEN 'Aaron'
END AS customer_name
FROM dataset

输出:

tbody> <<tr>亚伦亚伦亚伦

customer_name
亚伦