Signature
abs(n)
abs(n) function return absolute value of a number.
hive> SELECT * FROM emp;
OK
emp.id emp.name emp.hobbies emp.technology_experience emp.gender_age emp.rating
1 Hari ["Football","Cricket"] {"Java":"3.4Yrs","C":"4.5Yrs"} {"gender":"Male","age":30} -1.5
2 Chamu ["Trekking","Watching movies"] {"Selenium":"5.6Yrs"} {"gender":"Feale","age":38} 3.0
3 Sailu ["Chess","Listening to music"] {"EmbeddedC":"9Yrs"} {"gender":"Femle","age":32} 2.5
4 Gopi ["Cricket"] {"Datastage":"11Yrs"} {"gender":"Male","age":32} -0.7
Time taken: 0.047 seconds, Fetched: 4 row(s)
hive> ;
hive> ;
hive> SELECT name,abs(rating) from emp;
OK
name _c1
Hari 1.5
Chamu 3.0
Sailu 2.5
Gopi 0.7
Time taken: 0.045 seconds, Fetched: 4 row(s)
No comments:
Post a Comment