I¹m also interested in having an option to ³continue on error² without having advance knowledge of where errors lie.
On 5/26/15, 4:26 PM, "Andries Engelbrecht" <[email protected]> wrote: >The query will typically fail. What source data are you looking at that >may cause this issue? > >One way of working around this is to use a predicate to filter out rows >that may cause such issues. But pending on the use case, there can be >other ways of dealing with this. > >‹Andries > > >On May 26, 2015, at 11:56 AM, Alok Tanna <[email protected]> wrote: > >> 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? >
