【sql】 group by

hive -e "insert overwrite local directory '/home/mart_ipd/lirui/brand1'
row format delimited fields terminated by '\t'
select
brand_code,
barndname_cn,
item_third_cate_cd,
item_third_cate_name
from
gdm.gdm_m03_item_sku_act
where
dt = '2018-12-14'
and sku_valid_flag = 1
and item_valid_flag = 1
and sku_status_cd = '3001'
group by
brand_code,
barndname_cn,
item_third_cate_cd,
item_third_cate_name;"