Alphabetical Index

abs

Function

Calculates the modulus of a number.

add

Function

adds numbers together.

ALTER ROLE

SQL expression

Change role attributes.

ALTER SCHEMA

SQL expression

Change schema attributes.

ALTER USER

SQL expression

Change user attributes.

ALTER WORKER POOL

SQL expression

Changing the attributes of a worker pool.

ALTER WORKER POOL SET DEFAULT

SQL expression

Set default attributes of the worker pool.

any_value

Function

Returns the first value from argument other than NULL.

array_agg

Function

Returns a list containing all the values of a column.

AS

SQL expression

Элемент запроса SELECT.

avg

Function

Calculates the average of all non-empty values in argument.

BIGINT

Data type

Integers.

BIGINT[]

Data type

Arrays of integers.

BLOB

Data type

Binary objects.

BOOL

Data type

Boolean values.

BOOL[]

Data type

Arrays of Boolean values.

BOOLEAN

Data type

Псевдоним типа данных BOOL.

BOOLEAN[]

Data type

Псевдоним типа данных BOOL[].

BPCHAR

Data type

Псевдоним типа данных VARCHAR.

BPCHAR[]

Data type

Псевдоним типа данных VARCHAR[].

BYTEA

Data type

Псевдоним типа данных BLOB.

ceil

Function

rounds a number to the higher side.

ceiling

Function

Псевдоним функции ceil.

CHAR

Data type

Псевдоним типа данных VARCHAR.

CHAR[]

Data type

Псевдоним типа данных VARCHAR[].

char_length

Function

Псевдоним функции length.

character_length

Function

Псевдоним функции length.

chr

Function

Returns the character corresponding to the value of the code ASCII or code Unicode, given in argument.

coalesce

Function

Returns the first value other than NULL from the list of argument values.

concat

Function

Concatenates multiple strings, arrays or binary values.

contains

Function

Returns true if the specified string string contains the searched substring search_string.

cos

Function

Calculates the cosine of an angle given in radians.

count

Function

Calculates the number of rows in the group.

count(argument)

Function

Calculates the number of non-empty values in argument.

count_if

Function

Returns the number of records that satisfy the condition, or NULL if no records satisfy the condition.

CREATE ROLE

SQL expression

Create a new role.

CREATE SCHEMA

SQL expression

Create a new schema.

CREATE TABLE

SQL expression

Create a new table.

CREATE USER

SQL expression

Create a new user.

CREATE VIEW

SQL expression

Create a new view.

CREATE WORKER POOL

SQL expression

Create a worker pool.

cume_dist

Function

Cumulative allocation.

current_time

Function

Returns the current time as a value of type TIME.

DATE

Data type

Dates.

date_diff

Function

Returns the number of time units between two points in time as a value of type BIGINT.

date_part

Function

Псевдоним функции datepart.

date_trunc

Function

Reduces a moment in time to the specified precision.

datepart

Function

Returns the specified part of the date or time value as a value of type BIGINT.

DECIMAL

Data type

Псевдоним типа данных NUMERIC.

dense_rank

Function

The rank of the current string within the group without skips.

DESCRIBE TABLE

SQL expression

Display information about the table.

DESCRIBE USER

SQL expression

Display information about the user.

divide

Function

Returns the result of division as an integer.

DOUBLE

Data type

Real numbers with variable precision.

DROP ROLE

SQL expression

Reset a role.

DROP SCHEMA

SQL expression

Deleting a schema.

DROP TABLE

SQL expression

Deleting a table.

DROP USER

SQL expression

Reset user.

DROP VIEW

SQL expression

Deleting a view.

DROP WORKER POOL

SQL expression

Reset a worker pool.

even

Function

Rounds to the nearest even number away from zero.

exp

Function

Calculates the exponent of a number.

first_value

Function

Returns the value calculated using the specified expression for the first row of the group.

FLOAT

Data type

Псевдоним типа данных DOUBLE.

floor

Function

rounds a number to the smaller side.

fmod

Function

Returns the remainder of dividing the first argument by the second argument.

FROM

SQL expression

Элемент запроса SELECT.

from_json

Function

Псевдоним функции json_transform.

from_json_strict

Function

Псевдоним функции json_transform_strict.

gcd

Function

Calculates the greatest common divisor of two numbers.

generate_series

Function

Generates a list of values in the range between start and stop.

GEOMETRY

Data type

Geospatial data.

get_current_time

Function

Псевдоним функции current_time.

GRANT

SQL expression

Grant privileges.

greatest

Function

Returns the largest number specified in the arguments.

greatest_common_divisor

Function

Псевдоним функции gcd.

GROUP BY

SQL expression

Элемент запроса SELECT.

hash

Function

Returns a hash of the data from argument as a number.

HAVING

SQL expression

Элемент запроса SELECT.

ILIKE

SQL expression

Элемент запроса SELECT.

INSERT

SQL expression

Add data to a table.

INTEGER

Data type

Псевдоним типа данных BIGINT.

INTEGER[]

Data type

Псевдоним типа данных BIGINT[].

isfinite

Function

Checks whether a number is finite.

isinf

Function

Checks whether a number is infinite.

isnan

Function

Checks if the argument has the value NaN (Not a Number).

JOIN

SQL expression

Элемент запроса SELECT.

JSON

Data type

Data in JSON.

json

Function

Shortens the JSON structure record (removes spaces and line breaks).

json_array_length

Function

Returns the number of elements in the array at the specified path in JSON, or 0 if the specified path is not an array.

json_contains

Function

Checks if the JSON structure contains the JSON substructure specified in the second argument.

json_exists

Function

Checks if the JSON structure contains the specified path.

json_extract

Function

Extracts data from a JSON structure at the specified path. Returns the data as JSON.

json_extract_path

Function

Псевдоним функции json_extract.

json_extract_string

Function

Extracts data from a JSON structure at the specified path. Returns the data in VARCHAR form.

json_extract_string_path

Function

Псевдоним функции json_extract_string.

json_group_array

Function

Returns a JSON list containing all the values of a column.

json_group_object

Function

Returns a JSON structure containing all key-value pairs from the columns specified in the arguments.

json_keys

Function

Returns all keys from the specified JSON structure as VARCHAR[].

json_transform

Function

Transforms the JSON structure according to the specified structure.

json_transform_strict

Function

Transforms a JSON structure to match the specified structure. Issues an error if structures or types do not match.

json_valid

Function

Checks if the argument is a valid JSON structure.

json_value

Function

Retrieves values from a JSON structure at the specified path.

lag

Function

Returns the value calculated for the string shifted by offset rows from the current to the beginning of the group.

last_value

Function

Returns the value calculated by the specified expression for the last row of the group.

lcase

Function

Псевдоним функции lower.

lcm

Function

Calculates the least common multiple of two numbers.

lead

Function

Returns the value calculated for the row shifted by offset rows from the current row to the end of the group.

least

Function

Returns the smallest number specified in the arguments.

least_common_multiple

Function

Псевдоним функции lcm.

length

Function

Returns the number of characters in a string.

lgamma

Function

Calculates the logarithm of the gamma function.

LIKE

SQL expression

Элемент запроса SELECT.

LIMIT

SQL expression

Элемент запроса SELECT.

list

Function

Псевдоним функции array_agg.

ln

Function

Calculates the natural logarithm of a number.

log

Function

Calculates the logarithm of a number on base 10.

log10

Function

Псевдоним функции log.

log2

Function

Calculates the logarithm of a number on base 2.

lower

Function

Converts a string to lower case.

ltrim

Function

Removes all occurrences of any of the specified characters at the beginning of a string.

max

Function

Returns the maximum value available in argument.

md5

Function

Returns a hash MD5 of data from argument as a string (VARCHAR).

mean

Function

Псевдоним функции avg.

median

Function

Returns the median value of all non-empty values in argument.

min

Function

Returns the minimum value present in argument.

multiply

Function

Multiplies two numbers.

nextafter

Function

Returns the next value with variable precision (of type DOUBLE) after the first number towards the second number.

now

Function

Returns the current time as a value of type TIMESTAMPTZ.

nth_value

Function

Returns the value calculated for the nth row within a group (counting from 1).

ntile

Function

Splits each group into num subgroups of equal (as large as possible) size and returns the subgroup number.

NUMERIC

Data type

Real numbers with specified precision.

OFFSET

SQL expression

Элемент запроса SELECT.

ORDER BY

SQL expression

Элемент запроса SELECT.

percent_rank

Function

Calculates the relative rank of the current row within a group.

pi

Function

Returns the value of the number π.

pow

Function

Exposes the first argument to the degree given by the second argument.

power

Function

Псевдоним функции pow.

QUALIFY

SQL expression

Элемент запроса SELECT.

radians

Function

converts degrees to radians.

random

Function

Returns an arbitrary number (of type DOUBLE) between 0 and 1.

rank

Function

Returns the rank (with skips) of the current row within a group.

rank_dense

Function

Псевдоним функции dense_rank.

read_json

Function

reads a .json file and writes the read data to a table.

read_json_auto

Function

Псевдоним функции read_json.

regexp_extract

Function

Extracts a substring from a string using the given regular expression.

regexp_extract_all

Function

Extracts all non-overlapping substrings from a string using the given regular expression. Returns an array of substrings.

regexp_full_match

Function

Checks whether a regular expression overlaps a string completely.

regexp_matches

Function

Checks if a regular expression is contained within a string.

regexp_replace

Function

Replaces a substring covered by a regular expression with the specified string.

regexp_split_to_array

Function

Splits a string into parts, separated by a regular expression, and returns the parts as an array.

regexp_split_to_table

Function

Splits a string into parts separated by a regular expression, and returns the parts as strings.

REVOKE

SQL expression

Revoke privileges.

round

Function

`rounds the number from the first argument to the precision specified in the second argument.

round_even

Function

Round the number from the first argument to the nearest even number with the precision specified in the second argument.

roundbankers

Function

Псевдоним функции round_even.

row_number

Function

Returns the number of the current row in its group (counting from 1).

rtrim

Function

Removes all occurrences of any of the specified characters at the end of a string.

SELECT

SQL expression

Запрос SELECT.

setseed

Function

Fixes the initial value for the random() function.

sha1

Function

Returns a hash SHA-1 of the data from argument as a string (VARCHAR).

sha256

Function

Returns a hash SHA-256 of the data from argument as a string (VARCHAR).

SHOW ROLES

SQL expression

Display a list of all roles.

SHOW TABLES

SQL expression

Display a list of all tables.

SHOW USERS

SQL expression

Display a list of all users.

SHOW WORKER POOL

SQL expression

Display the current worker pool.

SHOW WORKER POOLS

SQL expression

Display a list of all worker pools.

sign

Function

Returns -1, 1 or 0 depending on the sign of the argument.

signbit

Function

Determines whether the sign bit of a real number is set.

SIMILAR TO

SQL expression

Элемент запроса SELECT.

sin

Function

Calculates the sine of an angle given in radians.

split

Function

Splits a string into two parts by the given separator.

sqrt

Function

Calculates the square root.

ST_Distance

Function

Calculates the distance between two points in the plane.

ST_Distance_Sphere

Function

Calculates the distance between two points on the sphere.

ST_Point

Function

Creates a point of type GEOMETRY.

str_split

Function

Псевдоним функции split.

STRING

Data type

Псевдоним типа данных VARCHAR.

STRING[]

Data type

Псевдоним типа данных VARCHAR[].

string_split

Function

Псевдоним функции split.

string_split_regex

Function

Псевдоним функции regexp_split_to_array.

string_to_array

Function

Псевдоним функции split.

strlen

Function

Returns the number of bytes in the string.

strptime

Function

Converts text to a point in time using the specified format.

subtract

Function

Subtracts the second argument from the first argument.

sum

Function

Calculates the sum of all non-empty values in argument.

TEXT

Data type

Псевдоним типа данных VARCHAR.

TEXT[]

Data type

Псевдоним типа данных VARCHAR[].

TIME

Data type

Time.

TIMESTAMP

Data type

Time stamps.

TIMESTAMPTZ

Data type

Time stamps with time zone.

tngri.sql

Python function

Executes the specified query SQL inside a cell of type Python.

tngri.upload_df

Python function

Uploads data from DataFrame to Tengri.

tngri.upload_file

Python function

Uploads data from a file to Tengri.

tngri.upload_s3

Python function

Uploads a file from the specified bucket S3 to Tengri.

trim

Function

Removes all occurrences of any of the specified characters on both sides of the string.

trunc

Function

Discards all characters after the decimal separator.

ucase

Function

Псевдоним функции upper.

UNION

SQL expression

Элемент запроса SELECT.

unnest

Function

Expands lists or structures from argument into a set of distinct values.

upper

Function

Converts a string to uppercase.

USE ROLE

SQL expression

Set the active role.

USE WORKER POOL

SQL expression

Set the current compute pool.

VARCHAR

Data type

Text strings.

VARCHAR[]

Data type

Arrays of text strings.

WHERE

SQL expression

Элемент запроса SELECT.

WITH

SQL expression

Элемент запроса SELECT.

%

Operator

Returns the remainder of the left argument divided by the right argument.

*

Operator

Multiplies the arguments.

+

Operator

Adds the right argument to the left argument.

-

Operator

Subtracts the right argument from the left argument.

/

Operator

Divides the left argument by the right argument.

^

Operator

Elevates the left argument to the degree given by the right argument.

||

Operator

Concatenates multiple strings, arrays or binary values.

~

Operator

Checks if the regular expression covers the string completely.