在HIVE中的一个查询语句执行后结果为:
江西省
上饶市
万年县,余干县,鄱阳县
安徽省
黄山市
休宁县,祁门县,黟县
河南省
开封市
兰考县,杞县,通许县
则最有可能的查询语句是( )
ASELECT province,city,concat_ws(',',collect_set(county)) FROM address
BSELECT province,city,concat_ws(',',county) FROM address GROUP BY province,city,county
CSELECT province,city,concat_ws(',',collect_list(county)) FROM address GROUP BY province,city,county
DSELECT province,city,concat_ws(',',collect_set(county)) FROM address GROUP BY province,city