right

Returns the rightmost len(len can be string type) characters from the string str, if len is less or equal than 0 the result is an empty string.

For the corresponding Databricks SQL function, see right function.

Syntax

Python

from pyspark.sql import functions as dbf

dbf.right(str=<str>, len=<len>)

Parameters

Parameter	Type	Description
str	pyspark.sql.Column or str	Input column or strings.
len	pyspark.sql.Column or str	Input column or strings, the rightmost len.

Parameter	Type	Description
str	pyspark.sql.Column or str	Input column or strings.
len	pyspark.sql.Column or str	Input column or strings, the rightmost len.

Examples

Python

df = spark.createDataFrame([("Spark SQL", 3,)], ['a', 'b'])
df.select(right(df.a, df.b).alias('r')).collect()

Output

[Row(r='SQL')]