I am trying to using the RAND() function and set a seed to generate a consistent set of 10 random values in my output following https://cloud.google.com/dataprep/docs/html/RAND-Function_57344757#int_value
With this query I am getting the error: No matching signature for function RAND for argument types: INT64.
:
rand_val as (
select value
from test
where RAND(3) < 10/ (select count(value) from test))
select * from rand_val
What am I doing wrong here?
Aucun commentaire:
Enregistrer un commentaire