I did this and voila it got accepted. I dont know what is wrong with it. I wrote the entire code correct, still it didnt accept :|
UPDATE "meteorites_temp" SET
"mass" = NULLIF("mass", ''),
"year" = NULLIF("year", ''),
"lat" = NULLIF("lat", ''),
"long" = NULLIF("long", '');