Top "User-defined-functions" questions

A function provided by the user of a program or an environment most often for spreadsheet type applications or database applications.

How to trace T-SQL function calls

I'm trying to debug a rather complicated formula evaluator written in T-SQL UDFs (don't ask) that recursively (but indirectly through …

tsql debugging trace user-defined-functions
How to create a udf in PySpark which returns an array of strings?

I have a udf which returns a list of strings. this should not be too hard. I pass in the …

python apache-spark pyspark apache-spark-sql user-defined-functions
MD5 function in SQLite

I am trying to port some sql from MySQL to SQLite, however we use mysql's md5() function, which doesn't exist …

sql sqlite md5 user-defined-functions
How do I call a UDF on a Spark DataFrame using JAVA?

Similar question as here, but don't have enough points to comment there. According to the latest Spark documentation an udf …

java apache-spark apache-spark-sql user-defined-functions
SQL massive performance difference using SELECT TOP x even when x is much higher than selected rows

I'm selecting some rows from a table valued function but have found an inexplicable massive performance difference by putting SELECT …

sql sql-server performance tsql user-defined-functions
Apache Spark -- Assign the result of UDF to multiple dataframe columns

I'm using pyspark, loading a large csv file into a dataframe with spark-csv, and as a pre-processing step I need …

python apache-spark pyspark apache-spark-sql user-defined-functions
Spark functions vs UDF performance?

Spark now offers predefined functions that can be used in dataframes, and it seems they are highly optimized. My original …

performance apache-spark pyspark apache-spark-sql user-defined-functions
Table-Valued Functions in ORACLE 11g ? ( parameterized views )

I've seen discussions about this in the past, such as here. But I'm wondering if somewhere along the line, maybe 10…

oracle views oracle11g parameterized user-defined-functions
PySpark - Pass list as parameter to UDF

I need to pass a list into a UDF, the list will determine the score/category of the distance. For …

python pyspark spark-dataframe user-defined-functions