org.apache.spark.sql.catalyst.expressions

Rank

case class Rank(children: Seq[Expression]) extends RankLike with Product with Serializable

The Rank function computes the rank of a value in a group of values. The result is one plus the number of rows preceding or equal to the current row in the ordering of the partition. The values will produce gaps in the sequence.

This documentation has been based upon similar documentation for the Hive and Presto projects.

children

to base the rank on; a change in the value of one the children will trigger a change in rank. This is an internal parameter and will be assigned by the Analyser.

Annotations
@ExpressionDescription()
Linear Supertypes
Ordering
  1. Alphabetic
  2. By inheritance
Inherited
  1. Rank
  2. RankLike
  3. AggregateWindowFunction
  4. WindowFunction
  5. DeclarativeAggregate
  6. Unevaluable
  7. Serializable
  8. Serializable
  9. AggregateFunction
  10. Expression
  11. TreeNode
  12. Product
  13. Equals
  14. AnyRef
  15. Any
  1. Hide All
  2. Show all
Learn more about member selection
Visibility
  1. Public
  2. All

Instance Constructors

  1. new Rank()

  2. new Rank(children: Seq[Expression])

    children

    to base the rank on; a change in the value of one the children will trigger a change in rank. This is an internal parameter and will be assigned by the Analyser.

Type Members

  1. implicit class RichAttribute extends AnyRef

    A helper class for representing an attribute used in merging two aggregation buffers.

Value Members

  1. final def !=(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  2. final def !=(arg0: Any): Boolean

    Definition Classes
    Any
  3. final def ##(): Int

    Definition Classes
    AnyRef → Any
  4. final def ==(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  5. final def ==(arg0: Any): Boolean

    Definition Classes
    Any
  6. val aggBufferAttributes: Seq[AttributeReference]

    Attributes of fields in aggBufferSchema.

    Attributes of fields in aggBufferSchema.

    Definition Classes
    RankLikeAggregateFunction
  7. final def aggBufferSchema: StructType

    An expression-based aggregate's bufferSchema is derived from bufferAttributes.

    An expression-based aggregate's bufferSchema is derived from bufferAttributes.

    Definition Classes
    DeclarativeAggregateAggregateFunction
  8. def apply(number: Int): TreeNode[_]

    Returns the tree node at the specified number, used primarily for interactive debugging.

    Returns the tree node at the specified number, used primarily for interactive debugging. Numbers for each node can be found in the numberedTreeString.

    Note that this cannot return BaseType because logical plan's plan node might return physical plan for innerChildren, e.g. in-memory relation logical plan node has a reference to the physical plan node it is referencing.

    Definition Classes
    TreeNode
  9. def argString: String

    Returns a string representing the arguments to this node, minus any children

    Returns a string representing the arguments to this node, minus any children

    Definition Classes
    TreeNode
  10. def asCode: String

    Returns a 'scala code' representation of this TreeNode and its children.

    Returns a 'scala code' representation of this TreeNode and its children. Intended for use when debugging where the prettier toString function is obfuscating the actual structure. In the case of 'pure' TreeNodes that only contain primitives and other TreeNodes, the result can be pasted in the REPL to build an equivalent Tree.

    Definition Classes
    TreeNode
  11. final def asInstanceOf[T0]: T0

    Definition Classes
    Any
  12. lazy val canonicalized: Expression

    Returns an expression where a best effort attempt has been made to transform this in a way that preserves the result but removes cosmetic variations (case sensitivity, ordering for commutative operations, etc.

    Returns an expression where a best effort attempt has been made to transform this in a way that preserves the result but removes cosmetic variations (case sensitivity, ordering for commutative operations, etc.) See Canonicalize for more details.

    deterministic expressions where this.canonicalized == other.canonicalized will always evaluate to the same result.

    Definition Classes
    Expression
  13. def checkInputDataTypes(): TypeCheckResult

    Checks the input data types, returns TypeCheckResult.success if it's valid, or returns a TypeCheckResult with an error message if invalid.

    Checks the input data types, returns TypeCheckResult.success if it's valid, or returns a TypeCheckResult with an error message if invalid. Note: it's not valid to call this method until childrenResolved == true.

    Definition Classes
    Expression
  14. val children: Seq[Expression]

    to base the rank on; a change in the value of one the children will trigger a change in rank.

    to base the rank on; a change in the value of one the children will trigger a change in rank. This is an internal parameter and will be assigned by the Analyser.

    Definition Classes
    RankTreeNode
  15. def childrenResolved: Boolean

    Returns true if all the children of this expression have been resolved to a specific schema and false if any still contains any unresolved placeholders.

    Returns true if all the children of this expression have been resolved to a specific schema and false if any still contains any unresolved placeholders.

    Definition Classes
    Expression
  16. def clone(): AnyRef

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  17. def collect[B](pf: PartialFunction[Expression, B]): Seq[B]

    Returns a Seq containing the result of applying a partial function to all elements in this tree on which the function is defined.

    Returns a Seq containing the result of applying a partial function to all elements in this tree on which the function is defined.

    Definition Classes
    TreeNode
  18. def collectFirst[B](pf: PartialFunction[Expression, B]): Option[B]

    Finds and returns the first TreeNode of the tree for which the given partial function is defined (pre-order), and applies the partial function to it.

    Finds and returns the first TreeNode of the tree for which the given partial function is defined (pre-order), and applies the partial function to it.

    Definition Classes
    TreeNode
  19. def collectLeaves(): Seq[Expression]

    Returns a Seq containing the leaves in this tree.

    Returns a Seq containing the leaves in this tree.

    Definition Classes
    TreeNode
  20. lazy val containsChild: Set[TreeNode[_]]

    Definition Classes
    TreeNode
  21. def dataType: DataType

    Returns the DataType of the result of evaluating this expression.

    Returns the DataType of the result of evaluating this expression. It is invalid to query the dataType of an unresolved expression (i.e., when resolved == false).

    Definition Classes
    AggregateWindowFunctionExpression
  22. def defaultResult: Option[Literal]

    Result of the aggregate function when the input is empty.

    Result of the aggregate function when the input is empty. This is currently only used for the proper rewriting of distinct aggregate functions.

    Definition Classes
    AggregateFunction
  23. def deterministic: Boolean

    Returns true when the current expression always return the same result for fixed inputs from children.

    Returns true when the current expression always return the same result for fixed inputs from children.

    Note that this means that an expression should be considered as non-deterministic if: - it relies on some mutable internal state, or - it relies on some implicit input that is not part of the children expression list. - it has non-deterministic child or children.

    An example would be SparkPartitionID that relies on the partition id returned by TaskContext. By default leaf expressions are deterministic as Nil.forall(_.deterministic) returns true.

    Definition Classes
    Expression
  24. final def doGenCode(ctx: CodegenContext, ev: ExprCode): ExprCode

    Returns Java source code that can be compiled to evaluate this expression.

    Returns Java source code that can be compiled to evaluate this expression. The default behavior is to call the eval method of the expression. Concrete expression implementations should override this to do actual code generation.

    ctx

    a CodegenContext

    ev

    an ExprCode with unique terms.

    returns

    an ExprCode containing the Java source code to generate the given expression

    Attributes
    protected
    Definition Classes
    UnevaluableExpression
  25. final def eq(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  26. final def eval(input: InternalRow = null): Any

    Returns the result of evaluating this expression on a given input Row

    Returns the result of evaluating this expression on a given input Row

    Definition Classes
    UnevaluableExpression
  27. val evaluateExpression: Expression

    An expression which returns the final value for this aggregate function.

    An expression which returns the final value for this aggregate function. Its data type should match this expression's dataType.

    Definition Classes
    RankLikeDeclarativeAggregate
  28. def fastEquals(other: TreeNode[_]): Boolean

    Faster version of equality which short-circuits when two treeNodes are the same instance.

    Faster version of equality which short-circuits when two treeNodes are the same instance. We don't just override Object.equals, as doing so prevents the scala compiler from generating case class equals methods

    Definition Classes
    TreeNode
  29. def finalize(): Unit

    Attributes
    protected[java.lang]
    Definition Classes
    AnyRef
    Annotations
    @throws( classOf[java.lang.Throwable] )
  30. def find(f: (Expression) ⇒ Boolean): Option[Expression]

    Find the first TreeNode that satisfies the condition specified by f.

    Find the first TreeNode that satisfies the condition specified by f. The condition is recursively applied to this node and all of its children (pre-order).

    Definition Classes
    TreeNode
  31. def flatArguments: Iterator[Any]

    Attributes
    protected
    Definition Classes
    Expression
  32. def flatMap[A](f: (Expression) ⇒ TraversableOnce[A]): Seq[A]

    Returns a Seq by applying a function to all nodes in this tree and using the elements of the resulting collections.

    Returns a Seq by applying a function to all nodes in this tree and using the elements of the resulting collections.

    Definition Classes
    TreeNode
  33. final def foldable: Boolean

    An aggregate function is not foldable.

    An aggregate function is not foldable.

    Definition Classes
    AggregateFunctionExpression
  34. def foreach(f: (Expression) ⇒ Unit): Unit

    Runs the given function on this node and then recursively on children.

    Runs the given function on this node and then recursively on children.

    f

    the function to be applied to each node in the tree.

    Definition Classes
    TreeNode
  35. def foreachUp(f: (Expression) ⇒ Unit): Unit

    Runs the given function recursively on children then on this node.

    Runs the given function recursively on children then on this node.

    f

    the function to be applied to each node in the tree.

    Definition Classes
    TreeNode
  36. val frame: SpecifiedWindowFrame

    Frame in which the window operator must be executed.

    Frame in which the window operator must be executed.

    Definition Classes
    AggregateWindowFunctionWindowFunction
  37. def genCode(ctx: CodegenContext): ExprCode

    Returns an ExprCode, that contains the Java source code to generate the result of evaluating the expression on an input row.

    Returns an ExprCode, that contains the Java source code to generate the result of evaluating the expression on an input row.

    ctx

    a CodegenContext

    returns

    ExprCode

    Definition Classes
    Expression
  38. def generateTreeString(depth: Int, lastChildren: Seq[Boolean], builder: StringBuilder, verbose: Boolean, prefix: String = "", addSuffix: Boolean = false): StringBuilder

    Appends the string represent of this node and its children to the given StringBuilder.

    Appends the string represent of this node and its children to the given StringBuilder.

    The i-th element in lastChildren indicates whether the ancestor of the current node at depth i + 1 is the last child of its own parent node. The depth of the root node is 0, and lastChildren for the root node should be empty.

    Note that this traversal (numbering) order must be the same as getNodeNumbered.

    Definition Classes
    TreeNode
  39. final def getClass(): Class[_]

    Definition Classes
    AnyRef → Any
  40. def hashCode(): Int

    Definition Classes
    TreeNode → AnyRef → Any
  41. val increaseRank: If

    Increase the rank when the current rank == 0 or when the one of order attributes changes.

    Increase the rank when the current rank == 0 or when the one of order attributes changes.

    Attributes
    protected
    Definition Classes
    RankLike
  42. val increaseRowNumber: Add

    Attributes
    protected
    Definition Classes
    RankLike
  43. val initialValues: Seq[Literal]

    Expressions for initializing empty aggregation buffers.

    Expressions for initializing empty aggregation buffers.

    Definition Classes
    RankLikeDeclarativeAggregate
  44. def innerChildren: Seq[TreeNode[_]]

    All the nodes that should be shown as a inner nested tree of this node.

    All the nodes that should be shown as a inner nested tree of this node. For example, this can be used to show sub-queries.

    Attributes
    protected
    Definition Classes
    TreeNode
  45. final lazy val inputAggBufferAttributes: Seq[AttributeReference]

  46. final def isInstanceOf[T0]: Boolean

    Definition Classes
    Any
  47. def jsonFields: List[(String, JValue)]

    Attributes
    protected
    Definition Classes
    TreeNode
  48. def makeCopy(newArgs: Array[AnyRef]): Expression

    Creates a copy of this type of tree node after a transformation.

    Creates a copy of this type of tree node after a transformation. Must be overridden by child classes that have constructor arguments that are not present in the productIterator.

    newArgs

    the new product arguments.

    Definition Classes
    TreeNode
  49. def map[A](f: (Expression) ⇒ A): Seq[A]

    Returns a Seq containing the result of applying the given function to each node in this tree in a preorder traversal.

    Returns a Seq containing the result of applying the given function to each node in this tree in a preorder traversal.

    f

    the function to be applied.

    Definition Classes
    TreeNode
  50. def mapChildren(f: (Expression) ⇒ Expression): Expression

    Returns a copy of this node where f has been applied to all the nodes children.

    Returns a copy of this node where f has been applied to all the nodes children.

    Definition Classes
    TreeNode
  51. def mapProductIterator[B](f: (Any) ⇒ B)(implicit arg0: ClassTag[B]): Array[B]

    Efficient alternative to productIterator.map(f).toArray.

    Efficient alternative to productIterator.map(f).toArray.

    Attributes
    protected
    Definition Classes
    TreeNode
  52. lazy val mergeExpressions: Nothing

  53. final def ne(arg0: AnyRef): Boolean

    Definition Classes
    AnyRef
  54. def nodeName: String

    Returns the name of this type of TreeNode.

    Returns the name of this type of TreeNode. Defaults to the class name. Note that we remove the "Exec" suffix for physical operators here.

    Definition Classes
    TreeNode
  55. final def notify(): Unit

    Definition Classes
    AnyRef
  56. final def notifyAll(): Unit

    Definition Classes
    AnyRef
  57. def nullable: Boolean

    Definition Classes
    AggregateWindowFunctionExpression
  58. def numberedTreeString: String

    Returns a string representation of the nodes in this tree, where each operator is numbered.

    Returns a string representation of the nodes in this tree, where each operator is numbered. The numbers can be used with TreeNode.apply to easily access specific subtrees.

    The numbers are based on depth-first traversal of the tree (with innerChildren traversed first before children).

    Definition Classes
    TreeNode
  59. val one: Literal

    Attributes
    protected
    Definition Classes
    RankLike
  60. val orderAttrs: Seq[AttributeReference]

    Store the values of the window 'order' expressions.

    Store the values of the window 'order' expressions.

    Attributes
    protected
    Definition Classes
    RankLike
  61. val orderEquals: Expression with Serializable

    Predicate that detects if the order attributes have changed.

    Predicate that detects if the order attributes have changed.

    Attributes
    protected
    Definition Classes
    RankLike
  62. val orderInit: Seq[Literal]

    Attributes
    protected
    Definition Classes
    RankLike
  63. val origin: Origin

    Definition Classes
    TreeNode
  64. def otherCopyArgs: Seq[AnyRef]

    Args to the constructor that should be copied, but not transformed.

    Args to the constructor that should be copied, but not transformed. These are appended to the transformed args automatically by makeCopy

    returns

    Attributes
    protected
    Definition Classes
    TreeNode
  65. def p(number: Int): Expression

    Returns the tree node at the specified number, used primarily for interactive debugging.

    Returns the tree node at the specified number, used primarily for interactive debugging. Numbers for each node can be found in the numberedTreeString.

    This is a variant of apply that returns the node as BaseType (if the type matches).

    Definition Classes
    TreeNode
  66. def prettyJson: String

    Definition Classes
    TreeNode
  67. def prettyName: String

    Returns a user-facing string representation of this expression's name.

    Returns a user-facing string representation of this expression's name. This should usually match the name of the function in SQL.

    Definition Classes
    Expression
  68. val rank: AttributeReference

    Attributes
    protected
    Definition Classes
    RankLike
  69. def rankSource: Expression

    Different RankLike implementations use different source expressions to update their rank value.

    Different RankLike implementations use different source expressions to update their rank value. Rank for instance uses the number of rows seen, whereas DenseRank uses the number of changes.

    Attributes
    protected
    Definition Classes
    RankLike
  70. def references: AttributeSet

    Definition Classes
    Expression
  71. lazy val resolved: Boolean

    Returns true if this expression and all its children have been resolved to a specific schema and input data types checking passed, and false if it still contains any unresolved placeholders or has data types mismatch.

    Returns true if this expression and all its children have been resolved to a specific schema and input data types checking passed, and false if it still contains any unresolved placeholders or has data types mismatch. Implementations of expressions should override this if the resolution of this type of expression involves more than just the resolution of its children and type checking.

    Definition Classes
    Expression
  72. val rowNumber: AttributeReference

    Attributes
    protected
    Definition Classes
    RankLike
  73. def semanticEquals(other: Expression): Boolean

    Returns true when two expressions will always compute the same result, even if they differ cosmetically (i.

    Returns true when two expressions will always compute the same result, even if they differ cosmetically (i.e. capitalization of names in attributes may be different).

    See Canonicalize for more details.

    Definition Classes
    Expression
  74. def semanticHash(): Int

    Returns a hashCode for the calculation performed by this expression.

    Returns a hashCode for the calculation performed by this expression. Unlike the standard hashCode, an attempt has been made to eliminate cosmetic differences.

    See Canonicalize for more details.

    Definition Classes
    Expression
  75. def simpleString: String

    ONE line description of this node.

    ONE line description of this node.

    Definition Classes
    ExpressionTreeNode
  76. def sql: String

    Returns SQL representation of this expression.

    Returns SQL representation of this expression. For expressions extending NonSQLExpression, this method may return an arbitrary user facing string.

    Definition Classes
    RankLikeExpression
  77. def sql(isDistinct: Boolean): String

    Definition Classes
    AggregateFunction
  78. def stringArgs: Iterator[Any]

    The arguments that should be included in the arg string.

    The arguments that should be included in the arg string. Defaults to the productIterator.

    Attributes
    protected
    Definition Classes
    TreeNode
  79. final def synchronized[T0](arg0: ⇒ T0): T0

    Definition Classes
    AnyRef
  80. def toAggString(isDistinct: Boolean): String

    String representation used in explain plans.

    String representation used in explain plans.

    Definition Classes
    AggregateFunction
  81. def toAggregateExpression(isDistinct: Boolean): AggregateExpression

    Wraps this AggregateFunction in an AggregateExpression and set isDistinct field of the AggregateExpression to the given value because AggregateExpression is the container of an AggregateFunction, aggregation mode, and the flag indicating if this aggregation is distinct aggregation or not.

    Wraps this AggregateFunction in an AggregateExpression and set isDistinct field of the AggregateExpression to the given value because AggregateExpression is the container of an AggregateFunction, aggregation mode, and the flag indicating if this aggregation is distinct aggregation or not. An AggregateFunction should not be used without being wrapped in an AggregateExpression.

    Definition Classes
    AggregateFunction
  82. def toAggregateExpression(): AggregateExpression

    Wraps this AggregateFunction in an AggregateExpression because AggregateExpression is the container of an AggregateFunction, aggregation mode, and the flag indicating if this aggregation is distinct aggregation or not.

    Wraps this AggregateFunction in an AggregateExpression because AggregateExpression is the container of an AggregateFunction, aggregation mode, and the flag indicating if this aggregation is distinct aggregation or not. An AggregateFunction should not be used without being wrapped in an AggregateExpression.

    Definition Classes
    AggregateFunction
  83. def toJSON: String

    Definition Classes
    TreeNode
  84. def toString(): String

    Definition Classes
    ExpressionTreeNode → AnyRef → Any
  85. def transform(rule: PartialFunction[Expression, Expression]): Expression

    Returns a copy of this node where rule has been recursively applied to the tree.

    Returns a copy of this node where rule has been recursively applied to the tree. When rule does not apply to a given node it is left unchanged. Users should not expect a specific directionality. If a specific directionality is needed, transformDown or transformUp should be used.

    rule

    the function use to transform this nodes children

    Definition Classes
    TreeNode
  86. def transformDown(rule: PartialFunction[Expression, Expression]): Expression

    Returns a copy of this node where rule has been recursively applied to it and all of its children (pre-order).

    Returns a copy of this node where rule has been recursively applied to it and all of its children (pre-order). When rule does not apply to a given node it is left unchanged.

    rule

    the function used to transform this nodes children

    Definition Classes
    TreeNode
  87. def transformUp(rule: PartialFunction[Expression, Expression]): Expression

    Returns a copy of this node where rule has been recursively applied first to all of its children and then itself (post-order).

    Returns a copy of this node where rule has been recursively applied first to all of its children and then itself (post-order). When rule does not apply to a given node, it is left unchanged.

    rule

    the function use to transform this nodes children

    Definition Classes
    TreeNode
  88. def treeString(verbose: Boolean, addSuffix: Boolean = false): String

    Definition Classes
    TreeNode
  89. def treeString: String

    Returns a string representation of the nodes in this tree

    Returns a string representation of the nodes in this tree

    Definition Classes
    TreeNode
  90. val updateExpressions: Seq[Expression]

    Expressions for updating the mutable aggregation buffer based on an input row.

    Expressions for updating the mutable aggregation buffer based on an input row.

    Definition Classes
    RankLikeDeclarativeAggregate
  91. final def verboseString: String

    ONE line description of this node with more information

    ONE line description of this node with more information

    Definition Classes
    ExpressionTreeNode
  92. def verboseStringWithSuffix: String

    ONE line description of this node with some suffix information

    ONE line description of this node with some suffix information

    Definition Classes
    TreeNode
  93. final def wait(): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  94. final def wait(arg0: Long, arg1: Int): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  95. final def wait(arg0: Long): Unit

    Definition Classes
    AnyRef
    Annotations
    @throws( ... )
  96. def withNewChildren(newChildren: Seq[Expression]): Expression

    Returns a copy of this node with the children replaced.

    Returns a copy of this node with the children replaced. TODO: Validate somewhere (in debug mode?) that children are ordered correctly.

    Definition Classes
    TreeNode
  97. def withOrder(order: Seq[Expression]): Rank

    Definition Classes
    RankRankLike
  98. val zero: Literal

    Attributes
    protected
    Definition Classes
    RankLike

Inherited from RankLike

Inherited from AggregateWindowFunction

Inherited from WindowFunction

Inherited from DeclarativeAggregate

Inherited from Unevaluable

Inherited from Serializable

Inherited from Serializable

Inherited from AggregateFunction

Inherited from Expression

Inherited from TreeNode[Expression]

Inherited from Product

Inherited from Equals

Inherited from AnyRef

Inherited from Any

Ungrouped