vendredi 20 novembre 2020

BigQuery RAND() not accepting seed value

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