null handling

[Anonymous]

please look at the file i attached where i wan to eliminate nulls in date fields

[avinashelite]

try like this

if(len(trim(date))>0,Date)  as Date

if you want to eliminate the data where date is null then have a where condition like

LOAD *

from table

where len(trim(date))>0;

[brijeshvma]

Hi You can try With multiple way .. depend on your data like

if(IsNull(Date),'Null',Date) as Date  OR

if(len(trim(date))>0,Date)  as Date

[muthukumar77]

Hi,

Load *

from table

where len(trim(Date))<>0;