blob: c2e7f6d5d4ff1d0bef1623c98be0313537822bef [file] [log] [blame]
select intField i, count(intField) ci, strField s, count(strField) cs from dfs.drillTestDir.`DRILL-1248/group_by_parquet` group by i, 3 having ci > 1 AND cs > 2;