- 论坛徽章:
- 7
|
- [jay.liu@aliCloud chinaUnix]$ cat test.dat
- 2015-08-01 00:00,330227
- 2015-08-01 00:05,581618
- 2015-08-01 23:45,45821
- 2015-08-01 23:50,15178
- 2015-08-01 23:55,155802
- 2015-08-02 00:00,330227
- 2015-08-02 00:05,5816
- 2015-08-02 23:45,45821
- 2015-08-02 23:50,15178
- 2015-08-31 23:50,43225
- 2015-08-31 23:55,14300
- [jay.liu@aliCloud chinaUnix]$ awk -F"[ ,]" '{if(max[$1]=="" || max[$1] < $3){time[$1]=$2; max[$1]=$3}; sum[$1]+=$3}END{for(i in max) print i,max[i]/1024"M",time[i],sum[i]/1024/1024"G","a.test.com",max[i],sum[i]}' test.dat
- 2015-08-31 42.2119M 23:50 0.0548601G a.test.com 43225 57525
- 2015-08-01 567.986M 00:05 1.07636G a.test.com 581618 1128646
- 2015-08-02 322.487M 00:00 0.378649G a.test.com 330227 397042
复制代码 |
|