hi, i am facing an issue with null datetime in pig. reqcolVehicleDevices1= foreach fltrdVehicleDevices generate (dateadded is not null? ToDate(dateadded, 'YYYY-MM-DD HH:mm:ss'): null), offset ;
here dateadded is a column with datetime type and may be null values in a column . i need to handle it to convert some datediff pig function. i need to load datetimve value if it exist otherwise null values. when i tried above i am getting the bellow error ERROR org.apache.pig.tools.grunt.Grunt - ERROR 1050: <line 31, column 85> Unsupported input type for BinCond: left hand side: datetime; right hand side: chararray pls help me on this Thanks, Prabhakar
