Bigquery_UDF.txt

CREATE TEMPORARY FUNCTION do(x float64, y float64)
RETURNS float64
LANGUAGE js AS """
  function add(a, b) {
    return a + b;
  }
  return add(x, y)
""";
with data as (
  select *
  from {TABLE_NAME}
  limit 1 offset 0
)
select do(t1.value, t2.value) cos_dist
from data t1
cross join data t2