Mailing-List: contact dev-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
MIME-Version: 1.0
In-Reply-To: 
 <CAKTYAC_pnpa1v2k4RndLoAOL=a8b6C=nB3mb+o25kJ2e=fedEA@mail.gmail.com>
References: 
 <CA+HHcWv9gAzfP5AojNrZVK4ANkgkOUMM5r-U4tEDy7jyLZkrmA@mail.gmail.com>
	<CAKTYAC_pnpa1v2k4RndLoAOL=a8b6C=nB3mb+o25kJ2e=fedEA@mail.gmail.com>
Date: Tue, 6 Oct 2015 11:45:18 -0700
Message-ID: 
 <CAM7VCbEyrgNs1hfUXMNx4EZhURjpgjBxLC2uvBphx1=WC6fGqw@mail.gmail.com>
Subject: Re: [UDF] How do I return NULL
From: Steven Phillips <steven@dremio.com>
To: dev@drill.apache.org
Cc: Tugdual Grall <tugdual@gmail.com>
Content-Type: multipart/alternative; boundary=001a114226320f643205217408c6

--001a114226320f643205217408c6
Content-Type: text/plain; charset=UTF-8

In addition, your UDF needs to have the attribute "nulls =
NullHandling.INTERNAL"

On Tue, Oct 6, 2015 at 8:32 AM, Abdel Hakim Deneche <adeneche@maprtech.com>
wrote:

> Hi Tug,
>
> Let's say your UDF returns an int, your @output field will be defined like
> this:
>
> @Output NullableIntHolder out;
>
>
> To return a NULL you just have to set:
>
> out.isSet = 0;
>
>
> Thanks
>
> On Tue, Oct 6, 2015 at 1:56 AM, Tugdual Grall <tugdual@gmail.com> wrote:
>
> > Hello Drillers,
> >
> > I am developing a custom function and I would like to return NULL (based
> on
> > the value, for example if the varchar is '' I want my function to return
> > NULL)
> >
> > I have not found the way to do it.
> >
> >
> > Regards
> > Tug
> > @tgrall
> >
>
>
>
> --
>
> Abdelhakim Deneche
>
> Software Engineer
>
>   <http://www.mapr.com/>
>
>
> Now Available - Free Hadoop On-Demand Training
> <
> http://www.mapr.com/training?utm_source=Email&utm_medium=Signature&utm_campaign=Free%20available
> >
>

--001a114226320f643205217408c6--