Support Questions
Find answers, ask questions, and share your expertise

impala bug with random() function

New Contributor



I have an issue with random() function. 

I think it is a bug, because I try to set an upper limit to rand number, but it doesn't work well:

Welcome to the Impala shell.
Impala Shell v3.2.0-cdh6.2.0 (edc1994) default> with base_table as

Query: with base_table as
select random() as rand_num
select * from base_table
where 1=1
and rand_num < 0.01
Query submitted at: 2021-07-23 16:57:06 

| rand_num |
| 0.4784972579001435 |

Can you help me to solve this issue?