awk 处理

Question

hbase原始文本 第2列 cx 的数字x是预期结果的列号，value=后面的值是 预期结果对应的列号的值，按从小到大的列号把value=后面的值写到 一行02120aa_MERGE_20190711_551_1000020250198 column=aa:c4, timestamp=1562935948187, value=250
02120aa_MERGE_20190711_551_1000020250198 column=aa:c5, timestamp=1562935948187, value=20190519
02120aa_MERGE_20190711_551_1000020250198 column=aa:c2, timestamp=1562935948187, value=0
02120aa_MERGE_20190711_551_1000020250198 column=aa:c3, timestamp=1562935948187, value=551
02120aa_MERGE_20190711_551_1000020250198 column=aa:c1, timestamp=1562935948187, value=aa_MERGE_20190711_551_1000030
02120aa_MERGE_20190711_551_1000020250201 column=aa:c1, timestamp=1562935948187, value=aa_MERGE_20190711_551_1000020
02120aa_MERGE_20190711_551_1000020250201 column=aa:c3, timestamp=1562935948187, value=160
02120aa_MERGE_20190711_551_1000020250201 column=aa:c4, timestamp=1562935948187, value=167
02120aa_MERGE_20190711_551_1000020250201 column=aa:c2, timestamp=1562935948187, value=0558
02120aa_MERGE_20190711_551_1000020250201 column=aa:c5, timestamp=1562935948187, value=69
------------预期结果--------------
aa_MERGE_20190711_551_1000020|0558|160|167|69|02120aa_MERGE_20190711_551_1000020250201 
aa_MERGE_20190711_551_1000030|0|551|250|20190519|02120aa_MERGE_20190711_551_1000020250198 

Answer 1

推荐 http://www.zsythink.net/archives/tag/awk好东西！
{
    a[$1][$2]=$4;
}END{
    for(i in a){
        for(k in a[i]) {
            out[i] = sprintf("%s%s|", out[i],gensub(/value=(.+)/, "\\1", "g", a[i][k]));
        }
    }
    for(i in out){
        print(sprintf("%s%s", out[i],i));
    }
}