在使用grouping
(带有grouping sets
)时,有没有办法使用二进制表示法来写整数?
例如,我想写
select
case grouping(A, B, C, D)
when 0x0011 then 'ONLY AB' --
when 0x0101 then 'ONLY AC'
else 'ABCD'
end as label,
count(*) as statements,
from T
group by grouping sets ((A, B, C), (A, B), (A, C), (A))
而不是
select
case grouping(A, B, C, D)
when 3 then 'ONLY AB'
when 5 then 'ONLY BD'
else 'ABCD'
end as label,
count(*) as statements,
from T
group by grouping sets ((A, B, C), (A, B), (A, C), (B, D), (A))
发布于 2018-08-01 08:18:24
Presto不支持基数为2的文字,但您可以使用from_base
SELECT from_base('1101', 2);
https://stackoverflow.com/questions/51622408
复制相似问题