Hive useful query stuff

By | October 8, 2018
Hive useful query stuff

Generate random float numbers


SELECT ARRAY(
CAST(ROUND(RAND()* 100, 2) AS FLOAT)
, CAST(ROUND(RAND()* 1000, 2) AS FLOAT)
, CAST(ROUND(RAND()* 10000, 2) AS FLOAT)
, CAST(ROUND(RAND()* -100, 2) AS FLOAT)
, CAST(ROUND(RAND()* -1000, 2) AS FLOAT)
, CAST(ROUND(RAND()* -10000, 2) AS FLOAT)
)[CAST((FLOOR(RAND()*2)) AS INT)]
;

-- Output
Everytime you run above snippet, you get different value
+-------+
|  _c0  |
+-------+
| 63.0  |
+-------+

+---------+
|   _c0   |
+---------+
| 828.43  |
+---------+

+----------+
|   _c0    |
+----------+
| -327.25  |
+----------+

Leave a Reply

Your email address will not be published. Required fields are marked *