Функции Tuple

SELECT dotProduct((1, 2), (3, 4))

11

CREATE TABLE tab(t Tuple(a UInt32, b Tuple(c String, d UInt32))) ENGINE = MergeTree ORDER BY tuple();
INSERT INTO tab VALUES ((3, ('c', 4)));

SELECT flattenTuple(t) FROM tab;

┌─flattenTuple(t)┐
│ (3, 'c', 4)    │
└────────────────┘

SELECT tuple(1, 2)

(1,2)

SELECT tupleConcat((1, 2), ('a',), (true, false))

(1, 2, 'a', true, false)

SELECT tupleDivide((1, 2), (2, 3))

(0.5, 0.6666666666666666)

SELECT tupleDivideByNumber((1, 2), 0.5)

(2, 4)

SELECT tupleElement((1, 'hello'), 2)

hello

SELECT tupleElement((1, 'hello'), -1)

hello

CREATE TABLE example (values Tuple(name String, age UInt32)) ENGINE = Memory;
INSERT INTO example VALUES (('Alice', 30));
SELECT tupleElement(values, 'name') FROM example;

Alice

SELECT tupleElement((1, 2), 5, 'not_found')

not_found

SELECT (1, 'hello').2

hello

SELECT tupleHammingDistance((1, 2, 3), (3, 2, 1))

2

SELECT tupleHammingDistance(wordShingleMinHash(string), wordShingleMinHashCaseInsensitive(string)) FROM (SELECT 'ClickHouse is a column-oriented database management system for online analytical processing of queries.' AS string)

2

SELECT tupleIntDiv((15, 10, 5), (5, 5, 5))

(3, 2, 1)

SELECT tupleIntDiv((15, 10, 5), (5.5, 5.5, 5.5))

(2, 1, 0)

SELECT tupleIntDivByNumber((15, 10, 5), 5)

(3, 2, 1)

SELECT tupleIntDivByNumber((15.2, 10.7, 5.5), 5.8)

(2, 1, 0)

SELECT tupleIntDivOrZero((5, 10, 15), (0, 0, 0))

(0, 0, 0)

SELECT tupleIntDivOrZeroByNumber((15, 10, 5), 5)

(3, 2, 1)

SELECT tupleIntDivOrZeroByNumber((15, 10, 5), 0)

(0, 0, 0)

SELECT tupleMinus((1, 2), (2, 3))

(-1, -1)

SELECT tupleModulo((15, 10, 5), (5, 3, 2))

(0, 1, 1)

SELECT tupleModuloByNumber((15, 10, 5), 2)

(1, 0, 1)

SELECT tupleMultiply((1, 2), (2, 3))

(2, 6)

SELECT tupleMultiplyByNumber((1, 2), -2.1)

(-2.1, -4.2)

SELECT tupleNames(tuple(1 as a, 2 as b))

['a','b']

SELECT tupleNegate((1, 2))

(-1, -2)

SELECT tuplePlus((1, 2), (2, 3))

(3, 5)

SELECT tuplePositiveModuloByNumber((15, 10, 5), 2)

(1, 0, 1)

SELECT tupleToNameValuePairs(tuple(1593 AS user_ID, 2502 AS session_ID))

[('1', 1593), ('2', 2502)]

SELECT tupleToNameValuePairs(tuple(3, 2, 1))

[('1', 3), ('2', 2), ('3', 1)]

SELECT untuple(v6) FROM kv;

┌─_ut_1─┬─_ut_2─┐
│    33 │ ab    │
│    44 │ cd    │
│    55 │ ef    │
│    66 │ gh    │
│    77 │ kl    │
└───────┴───────┘

SELECT untuple((* EXCEPT (v2, v3),)) FROM kv;

┌─key─┬─v1─┬─v4─┬─v5─┬─v6────────┐
│   1 │ 10 │ 30 │ 15 │ (33,'ab') │
│   2 │ 25 │ 40 │  6 │ (44,'cd') │
│   3 │ 57 │ 10 │  5 │ (55,'ef') │
│   4 │ 55 │ 80 │ 90 │ (66,'gh') │
│   5 │ 30 │ 25 │ 55 │ (77,'kl') │
└─────┴────┴────┴────┴───────────┘