Thanks for the reply @nramanaiah. I seem to be unable to find an option 'metastore.msck.repair.enable.partition.retention' does it need to be added as a custom option and if so under which drop down? Thanks ... View more

@araujo thank you! I had gotten around the issue by using a replaceText loop to search for capitals within' the keys 1 at a time and prepend underscores, followed by a jolt to lowercase all keys. You're script returns the same result, very impressed. Thanks again.   ... View more

I have stolen to spec below from here: https://stackoverflow.com/questions/54696540/jolt-transformation-lowercase-all-keys which works in lowercasing all keys, however I ideally need the hyphens between the words.   [   {     // unwrap the keys and values into literal     // "key" : "A", "value" : "b"     "operation": "shift",     "spec": {       "*": {         "$": "&1.key",         "@": "&1.value"       }     }   },   {     "operation": "modify-overwrite-beta",     "spec": {       "*": {         // Now that the origional key         //  is on the "right hand side"         //  lowercase it         "key": "=toLower"       }     }   },   {     // pivot back, the now lowercased keys     "operation": "shift",     "spec": {       "*": {         "value": "@(1,key)"       }     }   } ] ... View more

Hi @VidyaSargur    I do not see an option for 'Accept as Solution' below the post, I assume because I didn't ask the original question.   Regards    ... View more

@araujo Thanks very useful indeed! ... View more

@araujo    Thanks André   What if I wanted to turn the key value pairs separated by '=' in json content as in the original question? for instance the following syslog:   converted into: [ { "sig" : "0", "arch" : "c000003e", "syscall" : "87" }]   I'm aware this can be done using regex to create attributes and then attributeToJson but some of my logs have hundreds of key value pairs so that's not an option, there must be a way to convert it using record processing? i.e convertRecord ... View more