Functions.Ntile(Int32) Method

Reference

Definition

Namespace:: Microsoft.Spark.Sql

Assembly:: Microsoft.Spark.dll

Package:: Microsoft.Spark v1.0.0

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Window function: returns the ntile group id (from 1 to n inclusive) in an ordered window partition. For example, if n is 4, the first quarter of the rows will get value 1, the second quarter will get 2, the third quarter will get 3, and the last quarter will get 4.

public static Microsoft.Spark.Sql.Column Ntile (int n);

static member Ntile : int -> Microsoft.Spark.Sql.Column

Public Shared Function Ntile (n As Integer) As Column

Parameters

n: Int32

Number of buckets

Returns

Column

Column object

Remarks

This is equivalent to the NTILE function in SQL.

Applies to