Help Center/ Data Lake Insight/ Spark SQL Syntax Reference/ Built-In Functions/ Mathematical Functions/ bin
Updated on 2023-10-25 GMT+08:00
View PDF

bin

This function is used to return the binary format of a.

Syntax

bin(BIGINT a)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

a

Yes

DOUBLE, BIGINT, DECIMAL, or STRING

The value is an integer.

If the value is not of the BIGINT type, the system will implicitly convert it to the BIGINT type for calculation.

Return Values

The return value is of the STRING type.

If the value of a is NULL, NULL is returned.

Example Code

The value 1 is returned.

select bin(1);

The value NULL is returned.

select bin(null);

The value 1000 is returned.

select bin(8);
The value 1000 is returned. 
select bin(8.123456);

Parent topic: Mathematical Functions