**************************** Expected results **************************** Query: select deptNo,NVL2(deptName,deptName,'Procrastrination') from departments_UDFTest; The null in the department name for department d008, should be returned as "Procrastrination". For the rest of the records, the query should return the data in Hive, as is.