In addition to the restrictions that apply to standard SQL scalar and aggregate functions, the following restrictions apply to UDFs:
- Scalar UDFs cannot appear in a partitioning expression of the CREATE TABLE statement.
- Aggregate UDFs cannot appear in recursive queries.