Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

Overview

Updated on 2023-10-25 GMT+08:00

The following table lists the functions provided by DLI, such as decode1, javahash, and max_pt.

Table 1 Added functions

Function

Syntax

Value Type

Description

decode1

decode1(<expression>, <search>, <result>[, <search>, <result>]...[, <default>])

Data type of the argument

Implements if-then-else branch selection.

javahash

javahash(string a)

STRING

Returns a hash value.

max_pt

max_pt(<table_full_name>)

STRING

Returns the name of the largest level-1 partition that contains data in a partitioned table and reads the data of this partition.

ordinal

ordinal(bigint <nth>, <var1>, <var2>[,...])

DOUBLE or DATETIME

Sorts input variables in ascending order and returns the value at the position specified by nth.

trans_array

trans_array (<num_keys>, <separator>, <key1>,<key2>,…,<col1>,<col2>,<col3>) as (<key1>,<key2>,...,<col1>, <col2>)

Data type of the argument

Converts an array split by a fixed separator in a column into multiple rows.

trunc_numeric

trunc_numeric(<number>[, bigint<decimal_places>])

DOUBLE or DECIMAL

Truncates the number value to a specified decimal place.

url_decode

url_decode(string <input>[, string <encoding>])

STRING

Converts a string from the application/x-www-form-urlencoded MIME format to regular characters.

url_encode

url_encode(string <input>[, string <encoding>])

STRING

Encodes a string in the application/x-www-form-urlencoded MIME format.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback