YonQL是否支持having

进击的bip

select o2o_sku_id as sku_id,count(id) as ct from AT18D4028C3F280009.AT18D4028C3F280009.o2oys_sku_mapping where dr = 0 group by o2o_sku_id having ct > 1 limit 10;



如上述sql,分组之后使用having条件，目前执行报错，去掉having可以执行，请问YonQL是否支持having？或者有其他写法？请各位大佬帮忙看一下

yonyouhmm

select o2o_sku_id as sku_id,count(id) as ct from AT18D4028C3F280009.AT18D4028C3F280009.o2oys_sku_mapping where dr = 0 group by o2o_sku_id having count(id) > 1 limit 10;