mysql - Impala 中 SELECT 语句的算术运算

Question

我正在编写一个查询，需要按行的类型进行分组，并将值除以总数以了解 IMPALA 中总数的百分比。例如:

Name                           performance
something type1 something           15
something type1 something           18
something type2 something           23
something something something       345
something type2 something           23

SELECT
CASE WHEN name like '%type1%' then 'type 1'
    WHEN name like '%type2%' then 'type2'
    ELSE 'other' END as type
,sum(performance) / (SELECT sum(performance) FROM table)
FROM table
GROUP BY type 

这给了我一个 AnalysisException 错误:选择列表中不支持子查询。谁能告诉我如何解决这个问题？

Answer 1

我认为它只需要“()”

SELECT
(CASE WHEN name like '%type1%' then 'type 1'
    WHEN name like '%type2%' then 'type2'
    Else 'other' END) as type
,sum(performance) / (SELECT sum(performance) FROM table)
FROM Table
GROUP BY type