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: