All rights reserved. STRICTLY CONFIDENTIAL Begin Content Area = 16,30 $ ￥ € $ €￥ $ £ ￥ ￡ ￥ UDF in ClickHouse Concept, Develpoment, and Application in ML Systems Begin Content Area = 16,30 2 structure and the well-designed API • We maintains a custom build Begin Content Area = 16,30 11 The UDF Magic Begin Content Area = 16,30 12 When the “Standard” SQL is not Enough Functionality Limitations pow(stddevPop(x), 3) FROM data Begin Content Area = 16,30 14 A UDF Can Do the Trick User-Defined Functions (UDF) • A function provided by the user UDF in ClickHouse • Scalar functions • Aggregate functions