In case of Drill ,lets say we are doing a sum of 20 rows via sql and if there is a value that is not a number but some junk - what happens to the sum? Does the whole sql fail or is that row ignored?
If it fails is there a way to process the 19 rows and just ignoring the junk row?
