I have many json files (sample given below) present in compressed format in a S3 folder (say s3://data/) as foo.json.gz, foo1.json.gz, foo2.json.gz. One of the category (say 1010) has been mistakenly assigned and it needs to be changed across all files to 1020. How do we go about making this change and re-packaging these files in S3 with modified content?
foo.json
{
"flower": "lilly",
"animal": "cat",
"category": "1010"
}
{
"flower": "rose",
"animal": "dog",
"category": "1000"
}
{
"flower": "daisy",
"animal": "cat",
"category": "1010"
}
