starRocks/doris 数据库不支持“PIVOT” 函数,就用直接简单的方法实现了,有大佬,可以赐教
SELECT
SUM(total) as '数据总量',
MAX(case when name = '1' then total else 0 end ) as '表1',
MAX(case when name = '2' then total else 0 end ) as '表2',
MAX(case when name = '3' then total else 0 end ) as '表3',
MAX(case when name = '4' then total else 0 end ) as '表4',
MAX(case when name = '5' then total else 0 end ) as '表5',
MAX(case when name = '6' then total else 0 end ) as '表6',
MAX(case when name = '7' then total else 0 end ) as '表7'
from (
select '1' as name, COUNT(1) as total from _info
union all
select '2' as name, COUNT(1) as total from group
union all
select '3' as name, COUNT(1) as total from child
union all
select '4' as name, COUNT(1) as total from relation
union all
select '5' as name, COUNT(1) as total from coordinates
union all
select '6' as name, COUNT(1) as total from part
union all
select '7' as name, COUNT(1) as total from replace
) a