Hive SQL case when + cast can not return correct answer

When I am using case when to trans string to float data, it can not get a correct response.

hive sql case when + cast can not get right answer

when i using case when to trans string to float data, it can not get right error,the sql is right here: