RE: rand() is not random by row

2015-12-16 Thread masahide.miura
Hello, Jason Thank you for your explanation. I see how rand function goes. > Drill comes with it's own native random() function that does what you want. I didn't know it! This is what I want, as you told. Thank you so much. -- Miura, Masahide

rand() is not random by row

2015-12-14 Thread masahide.miura
Hi, I found that rand() function does not reply random value. When I used it, all rows are same values through all rows. You can see this result with bellow query: select *, rand() from sys.boot limit 10 ver: 1.3.0 client: Web( drillhost:8047 ) environment: distributed on EMR Thanks. --