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 <ata...@exertdigital.com> 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?
