diff options
author | Alexander Smirnov <alex@ydb.tech> | 2024-11-20 11:14:58 +0000 |
---|---|---|
committer | Alexander Smirnov <alex@ydb.tech> | 2024-11-20 11:14:58 +0000 |
commit | 31773f157bf8164364649b5f470f52dece0a4317 (patch) | |
tree | 33d0f7eef45303ab68cf08ab381ce5e5e36c5240 /yql/essentials/tests/s-expressions/suites/Udf/PythonAvg.yql | |
parent | 2c7938962d8689e175574fc1e817c05049f27905 (diff) | |
parent | eff600952d5dfe17942f38f510a8ac2b203bb3a5 (diff) | |
download | ydb-31773f157bf8164364649b5f470f52dece0a4317.tar.gz |
Merge branch 'rightlib' into mergelibs-241120-1113
Diffstat (limited to 'yql/essentials/tests/s-expressions/suites/Udf/PythonAvg.yql')
-rw-r--r-- | yql/essentials/tests/s-expressions/suites/Udf/PythonAvg.yql | 57 |
1 files changed, 57 insertions, 0 deletions
diff --git a/yql/essentials/tests/s-expressions/suites/Udf/PythonAvg.yql b/yql/essentials/tests/s-expressions/suites/Udf/PythonAvg.yql new file mode 100644 index 0000000000..62dc07db05 --- /dev/null +++ b/yql/essentials/tests/s-expressions/suites/Udf/PythonAvg.yql @@ -0,0 +1,57 @@ +( +(let config (DataSource 'config)) +(let world (Configure! world config 'PureDataSource 'yt)) + +# prepare python udf +(let ui32 (DataType 'Uint32)) +(let dbl (DataType 'Double)) +(let rt (ResourceType 'Python2)) + +(let udfScript (String '@@ +class AvgCalc: + def __init__(self): + self.__count = 0 + self.__sum = 0 + + def add(self, value): + self.__sum = self.__sum + value + self.__count = self.__count + 1 + + def result(self): + return self.__sum / float(self.__count) + +def avg_create(): + return AvgCalc() + +def avg_add(avg, value): + avg.add(value) + return avg + +def avg_result(avg): + return avg.result() + +@@)) + +(let avgCreate (ScriptUdf 'Python 'avg_create (CallableType '() '(rt)) udfScript)) +(let avgAdd (ScriptUdf 'Python 'avg_add (CallableType '() '(rt) '(rt) '(ui32)) udfScript)) +(let avgResult (ScriptUdf 'Python 'avg_result (CallableType '() '(dbl) '(rt)) udfScript)) + +# data +(let x (Uint32 '10)) +(let y (Uint32 '30)) +(let z (Uint32 '5)) + +# call udfs +(let avg (Apply avgCreate)) +(let avg (Apply avgAdd avg x)) +(let avg (Apply avgAdd avg y)) +(let avg (Apply avgAdd avg z)) +(let result (Apply avgResult avg)) + +# output result with type +(let res_sink (DataSink 'result)) +(let world (Write! world res_sink (Key) result '( '('type) ))) + +# finish +(return (Commit! world res_sink)) +) |