Hi Everyone, I've come across a very strange behavior of impala. My aim is to generate random numbers for each rows, and then classified based on the probability to each segment. For some reason, the below query fails, and mixing up segments. select case when random < 0.005 then 1 when random < 0.0175 and random >= 0.005 then 2 when random < 0.0175 and random >= 0.0175 then 3 when random < 0.2500 and random >= 0.0800 then 4 else 0 end segment, min(random),max(random), count(ANYID) from ( select ANYID,RAND(unix_timestamp()) random from ANYTABLE limit 1000000) j group by segment     Can anyone help me with any explanation? I simply can't get my head around. Thank you so much, Andras ... View more