Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Built-in Functions/ String Functions/ reverse
Updated on 2023-10-25 GMT+08:00
View PDF

reverse

This function is used to return a string in reverse order.

Syntax

reverse(string <str>)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

str

Yes

STRING

If the value is of the BIGINT, DOUBLE, DECIMAL, or DATETIME type, the value is implicitly converted to the STRING type for calculation.

Return Values

The return value is of the STRING type.

  • If the value of str is not of the STRING, BIGINT, DOUBLE, DECIMAL, or DATETIME type, an error is reported.
  • If the value of str is NULL, NULL is returned.

Example Code

The value LQS krapS is returned.

SELECT reverse('Spark SQL');

The value [3,4,1,2] is returned.

SELECT reverse(array(2, 1, 4, 3));
Parent topic: String Functions