drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andries Engelbrecht <aengelbre...@maprtech.com>
Subject Re: SQL query : Question
Date Tue, 26 May 2015 20:26:10 GMT
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 <atanna@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?


Mime
View raw message