yql/essentials/tests/sql/suites/select/deep_udf_call.sql


1
2
3
4
5
6
7
8
9
10
11

/* postgres can not */
USE plato;

$data = (
    SELECT
        Math::Pi() * CAST(subkey AS Double) AS rad
    FROM Input
);

--INSERT INTO Output
SELECT Math::Sqrt(Math::Sin(rad) * Math::Sin(rad) + Math::Cos(rad) * Math::Cos(rad)) FROM $data