blob: 1dee86f19cb2fe47f1ce90cb6b4975ab0b118d8d [file] [log] [blame]
SELECT count(t1.c4), t2.c8
FROM
(select c4 from `t_alltype.parquet` ) t1,
(select c4, c8 from `t_alltype.parquet` ) t2
WHERE t1.c4 = t2.c4 OR (t1.c4 IS NULL AND t2.c4 IS NULL) GROUP BY t2.c8;