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

printf

This function is used to print the input in a specific format.

Syntax

printf(String format, Obj... args)

Parameters

Table 1 Parameters

Parameter

Mandatory

Type

Description

format

Yes

STRING

Output format

Obj

No

STRING

Other input parameters

Return Values

The return value is of the STRING type.

The value is returned after the parameters that filled in Obj are specified for format.

Example Code

The string name: Zhang San, age: 20, gender: female, place of origin: city 1 is returned.

SELECT printf('Name: %s, Age: %d, Gender: %s, Place of origin: %s', "Zhang San", 20, "Female", "City 1");
Parent topic: String Functions