I have some DOBs, and some fields are empty others apparently were filled by trained monkeys, but while most data is accurate, some data is not.
As you saw from my other post, I am trying to get the age for those DOBs that are valid... My function works, until I get to a record that is not valid and I get something like this: Error: SYSTEM ERROR: IllegalFieldValueException: Value 0 for monthOfYear must be in the range [1,12] Is there a good "Try -> Except" type solution that will grant me the valid data if things worked, and just return 0 or whatever I specify if there is an error? I could try casting the data, but if it fails won't it kill my query? Basically I want it to keep going if it fails... not sure if Drill has this ability, but thought I would ask.
