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

impala bug with random() function

New Contributor

Hi,

 

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?

0 REPLIES 0