Functions 
Abs(Column)- Acos(Column)
- Acos(String)
- Acosh(Column)
- Acosh(String)
- AddMonths(Column, Column)
- AddMonths(Column, Int32)
- ApproxCountDistinct(Column)
- ApproxCountDistinct(String)
- ApproxCountDistinct(Column, Double)
- ApproxCountDistinct(String, Double)
- Array(Column[])
- Array(String, String[])
- ArrayContains(Column, Object)
- ArrayDistinct(Column)
- ArrayExcept(Column, Column)
- ArrayIntersect(Column, Column)
- ArrayJoin(Column, String)
- ArrayJoin(Column, String, String)
- ArrayMax(Column)
- ArrayMin(Column)
- ArrayPosition(Column, Object)
- ArrayRemove(Column, Object)
- ArrayRepeat(Column, Column)
- ArrayRepeat(Column, Int32)
- ArraySort(Column)
- ArraysOverlap(Column, Column)
- ArraysZip(Column[])
- ArrayUnion(Column, Column)
- Asc(String)
- Ascii(Column)
- AscNullsFirst(String)
- AscNullsLast(String)
- Asin(Column)
- Asin(String)
- Asinh(Column)
- Asinh(String)
- AssertTrue(Column)
- AssertTrue(Column, Column)
- Atan(Column)
- Atan(String)
- Atan2(Column, Column)
- Atan2(Column, Double)
- Atan2(Column, String)
- Atan2(Double, Column)
- Atan2(Double, String)
- Atan2(String, Column)
- Atan2(String, Double)
- Atan2(String, String)
- Atanh(Column)
- Atanh(String)
- Avg(Column)
- Avg(String)
- Base64(Column)
- Bin(Column)
- Bin(String)
- Bitwise_Not(Column)
- BitwiseNOT(Column)
- Broadcast(DataFrame)
- Bround(Column)
- Bround(Column, Int32)
- Bucket(Column, Column)
- Bucket(Int32, Column)
- Call_UDF(String, Column[])
- CallUDF(String, Column[])
- Cbrt(Column)
- Cbrt(String)
- Ceil(Column)
- Ceil(String)
- Coalesce(Column[])
- Col(String)
- CollectList(Column)
- CollectList(String)
- CollectSet(Column)
- CollectSet(String)
- Column(String)
- Concat(Column[])
- ConcatWs(String, Column[])
- Conv(Column, Int32, Int32)
- Corr(Column, Column)
- Corr(String, String)
- Cos(Column)
- Cos(String)
- Cosh(Column)
- Cosh(String)
- Count_Distinct(Column, Column[])
- Count(Column)
- Count(String)
- CountDistinct(Column, Column[])
- CountDistinct(String, String[])
- CovarPop(Column, Column)
- CovarPop(String, String)
- CovarSamp(Column, Column)
- CovarSamp(String, String)
- Crc32(Column)
- CumeDist()
- CurrentDate()
- CurrentRow()
- CurrentTimestamp()
- DateAdd(Column, Column)
- DateAdd(Column, Int32)
- DateDiff(Column, Column)
- DateFormat(Column, String)
- DateSub(Column, Column)
- DateSub(Column, Int32)
- DateTrunc(String, Column)
- DayOfMonth(Column)
- DayOfWeek(Column)
- DayOfYear(Column)
- Days(Column)
- Decode(Column, String)
- Degrees(Column)
- Degrees(String)
- DenseRank()
- Desc(String)
- DescNullsFirst(String)
- DescNullsLast(String)
- ElementAt(Column, Object)
- Encode(Column, String)
- Exp(Column)
- Exp(String)
- Explode(Column)
- ExplodeOuter(Column)
- Expm1(Column)
- Expm1(String)
- Expr(String)
- Factorial(Column)
- First(Column, Boolean)
- First(String, Boolean)
- Flatten(Column)
- Floor(Column)
- Floor(String)
- FormatNumber(Column, Int32)
- FormatString(String, Column[])
- FromCsv(Column, Column, Dictionary<String, String>)
- FromCsv(Column, StructType, Dictionary<String, String>)
- FromJson(Column, Column, Dictionary<String, String>)
- FromJson(Column, String, Dictionary<String, String>)
- FromUnixTime(Column)
- FromUnixTime(Column, String)
- FromUtcTimestamp(Column, Column)
- FromUtcTimestamp(Column, String)
- GetJsonObject(Column, String)
- Greatest(Column[])
- Greatest(String, String[])
- Grouping(Column)
- Grouping(String)
- GroupingId(Column[])
- GroupingId(String, String[])
- Hash(Column[])
- Hex(Column)
- Hour(Column)
- Hours(Column)
- Hypot(Column, Column)
- Hypot(Column, Double)
- Hypot(Column, String)
- Hypot(Double, Column)
- Hypot(Double, String)
- Hypot(String, Column)
- Hypot(String, Double)
- Hypot(String, String)
- InitCap(Column)
- InputFileName()
- Instr(Column, String)
- IsNaN(Column)
- IsNull(Column)
- JsonTuple(Column, String[])
- Kurtosis(Column)
- Kurtosis(String)
- Lag(Column, Int32, Object)
- Lag(String, Int32, Object)
- Lag(Column, Int32, Object, Boolean)
- Last(Column, Boolean)
- Last(String, Boolean)
- LastDay(Column)
- Lead(Column, Int32, Object)
- Lead(String, Int32, Object)
- Lead(Column, Int32, Object, Boolean)
- Least(Column[])
- Least(String, String[])
- Length(Column)
- Levenshtein(Column, Column)
- Lit(Object)
- Locate(String, Column)
- Locate(String, Column, Int32)
- Log(Column)
- Log(String)
- Log(Double, Column)
- Log(Double, String)
- Log10(Column)
- Log10(String)
- Log1p(Column)
- Log1p(String)
- Log2(Column)
- Log2(String)
- Lower(Column)
- Lpad(Column, Int32, String)
- Ltrim(Column)
- Ltrim(Column, String)
- Map(Column[])
- MapConcat(Column[])
- MapEntries(Column)
- MapFromArrays(Column, Column)
- MapFromEntries(Column)
- MapKeys(Column)
- MapValues(Column)
- Max(Column)
- Max(String)
- Md5(Column)
- Mean(Column)
- Mean(String)
- Min(Column)
- Min(String)
- Minute(Column)
- MonotonicallyIncreasingId()
- Month(Column)
- Months(Column)
- MonthsBetween(Column, Column)
- MonthsBetween(Column, Column, Boolean)
- NaNvl(Column, Column)
- Negate(Column)
- NextDay(Column, Column)
- NextDay(Column, String)
- Not(Column)
- NthValue(Column, Int32, Boolean)
- Ntile(Int32)
- Overlay(Column, Column, Column)
- Overlay(Column, Column, Column, Column)
- PercentileApprox(Column, Column, Column)
- PercentRank()
- Pmod(Column, Column)
- PosExplode(Column)
- PosExplodeOuter(Column)
- Pow(Column, Column)
- Pow(Column, Double)
- Pow(Column, String)
- Pow(Double, Column)
- Pow(Double, String)
- Pow(String, Column)
- Pow(String, Double)
- Pow(String, String)
- Product(Column)
- Quarter(Column)
- Radians(Column)
- Radians(String)
- RaiseError(Column)
- Rand()
- Rand(Int64)
- Randn()
- Randn(Int64)
- Rank()
- RegexpExtract(Column, String, Int32)
- RegexpReplace(Column, Column, Column)
- RegexpReplace(Column, String, String)
- Repeat(Column, Int32)
- Reverse(Column)
- Rint(Column)
- Rint(String)
- Round(Column)
- Round(Column, Int32)
- RowNumber()
- Rpad(Column, Int32, String)
- Rtrim(Column)
- Rtrim(Column, String)
- SchemaOfCsv(Column)
- SchemaOfCsv(String)
- SchemaOfCsv(Column, Dictionary<String, String>)
- SchemaOfJson(Column)
- SchemaOfJson(String)
- SchemaOfJson(Column, Dictionary<String, String>)
- Second(Column)
- Sentences(Column)
- Sentences(Column, Column, Column)
- Sequence(Column, Column)
- Sequence(Column, Column, Column)
- Session_Window(Column, Column)
- Session_Window(Column, String)
- Sha1(Column)
- Sha2(Column, Int32)
- Shiftleft(Column, Int32)
- ShiftLeft(Column, Int32)
- Shiftright(Column, Int32)
- ShiftRight(Column, Int32)
- Shiftrightunsigned(Column, Int32)
- ShiftRightUnsigned(Column, Int32)
- Shuffle(Column)
- Signum(Column)
- Signum(String)
- Sin(Column)
- Sin(String)
- Sinh(Column)
- Sinh(String)
- Size(Column)
- Skewness(Column)
- Skewness(String)
- Slice(Column, Column, Column)
- Slice(Column, Int32, Int32)
- SortArray(Column, Boolean)
- Soundex(Column)
- SparkPartitionId()
- Split(Column, String)
- Split(Column, String, Int32)
- Sqrt(Column)
- Sqrt(String)
- Stddev(Column)
- Stddev(String)
- StddevPop(Column)
- StddevPop(String)
- StddevSamp(Column)
- StddevSamp(String)
- Struct(Column[])
- Struct(String, String[])
- Substring(Column, Int32, Int32)
- SubstringIndex(Column, String, Int32)
- Sum_Distinct(Column)
- Sum(Column)
- Sum(String)
- SumDistinct(Column)
- SumDistinct(String)
- Tan(Column)
- Tan(String)
- Tanh(Column)
- Tanh(String)
- TimestampSeconds(Column)
- ToCsv(Column)
- ToCsv(Column, Dictionary<String, String>)
- ToDate(Column)
- ToDate(Column, String)
- ToJson(Column, Dictionary<String, String>)
- ToTimestamp(Column)
- ToTimestamp(Column, String)
- ToUtcTimestamp(Column, Column)
- ToUtcTimestamp(Column, String)
- Translate(Column, String, String)
- Trim(Column)
- Trim(Column, String)
- Trunc(Column, String)
- Udf<TResult>(Func<TResult>)
- Udf(Func<Row>, StructType)
- Udf<T>(Func<T, Row>, StructType)
- Udf<T, TResult>(Func<T, TResult>)
- Udf<T1, T2>(Func<T1, T2, Row>, StructType)
- Udf<T1, T2, TResult>(Func<T1, T2, TResult>)
- Udf<T1, T2, T3>(Func<T1, T2, T3, Row>, StructType)
- Udf<T1, T2, T3, TResult>(Func<T1, T2, T3, TResult>)
- Udf<T1, T2, T3, T4>(Func<T1, T2, T3, T4, Row>, StructType)
- Udf<T1, T2, T3, T4, TResult>(Func<T1, T2, T3, T4, TResult>)
- Udf<T1, T2, T3, T4, T5>(Func<T1, T2, T3, T4, T5, Row>, StructType)
- Udf<T1, T2, T3, T4, T5, TResult>(Func<T1, T2, T3, T4, T5, TResult>)
- Udf<T1, T2, T3, T4, T5, T6>(Func<T1, T2, T3, T4, T5, T6, Row>, StructType)
- Udf<T1, T2, T3, T4, T5, T6, TResult>(Func<T1, T2, T3, T4, T5, T6, TResult>)
- Udf<T1, T2, T3, T4, T5, T6, T7>(Func<T1, T2, T3, T4, T5, T6, T7, Row>, StructType)
- Udf<T1, T2, T3, T4, T5, T6, T7, TResult>(Func<T1, T2, T3, T4, T5, T6, T7, TResult>)
- Udf<T1, T2, T3, T4, T5, T6, T7, T8>(Func<T1, T2, T3, T4, T5, T6, T7, T8, Row>, StructType)
- Udf<T1, T2, T3, T4, T5, T6, T7, T8, TResult>(Func<T1, T2, T3, T4, T5, T6, T7, T8, TResult>)
- Udf<T1, T2, T3, T4, T5, T6, T7, T8, T9>(Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, Row>, StructType)
- Udf<T1, T2, T3, T4, T5, T6, T7, T8, T9, TResult>(Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, TResult>)
- Udf<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10>(Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, Row>, StructType)
- Udf<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, TResult>(Func<T1, T2, T3, T4, T5, T6, T7, T8, T9, T10, TResult>)
- Unbase64(Column)
- UnboundedFollowing()
- UnboundedPreceding()
- Unhex(Column)
- UnixTimestamp()
- UnixTimestamp(Column)
- UnixTimestamp(Column, String)
- Upper(Column)
- Variance(Column)
- Variance(String)
- VarPop(Column)
- VarPop(String)
- VarSamp(Column)
- VarSamp(String)
- WeekOfYear(Column)
- When(Column, Object)
- Window(Column, String)
- Window(Column, String, String)
- Window(Column, String, String, String)
- XXHash64(Column[])
- Year(Column)
- Years(Column)
netstandard2.1
namespace Microsoft.Spark.Sql
{
public static class Functions : Object
{
public static Column Factorial(Column column);
}
}
| .NET | 5.06.07.08.09.010.0 |
|---|---|
| .NET Core | 2.02.12.23.03.1 |
| .NET Framework | 4.6.14.6.24.74.7.14.7.24.84.8.1 |
| .NET Standard | 2.02.1 |
Information specific to netstandard2.1 | |
| Assembly | Microsoft.Spark , Version=2.1.1.0, PublicKeyToken=cc7b13ffcd2ddd51 |
| Referencing | Your project needs a package reference to |
| Package | Microsoft.Spark (2.1.1) netstandard2.1 |
| Platform Restrictions | This framework does not have platform annotations. |
- Built-in API
- Package-provided API