hive查询分组添加行数

base_info = spark.sql("select index, type,id, score, idcardinput,banknoteorremit,idcard,\
        accounttype,accountopendate,nameinput,subaccount,usablebalance,querydate as querydate_base,balance as balance_base,\
        accountopenbankname,name,currency as currency_base,account,status \
        from dp_ods.o_ws_bankv3_baseinfo_s \
        where (etl_date=date_sub(from_unixtime(unix_timestamp(),'yyyy-MM-dd'),4))")