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 | +----------+