YY
system.merges
?Size: a a a
YY
system.merges
?SK
system.merges
?SK
YY
YK
YK
YK
SS
SS
SS
DROP TABLE IF EXISTS TestTable;
CREATE TABLE TestTable
(
dtStart DateTime,
dtEnd DateTime
) ENGINE Memory();
INSERT INTO
TestTable
VALUES
('2019-11-01 07:40:48', '2019-11-12 08:40:48');
SELECT *
FROM
TestTable;
SELECT
dtStart,
dtEnd,
arrayJoin(
arrayFilter(
x -> x BETWEEN dtStart AND dtEnd,
arrayConcat(
arrayMap(
x -> toDate('2019-11-01') + x,
range(toUInt32(toDate('2019-11-05') - toDate('2019-11-01')))
),
arrayMap(
x -> toDate('2019-11-10') + x,
range(toUInt32(toDate('2019-11-15') - toDate('2019-11-10')))
)
)
)
)
FROM
TestTable;
DC
DROP TABLE IF EXISTS TestTable;
CREATE TABLE TestTable
(
dtStart DateTime,
dtEnd DateTime
) ENGINE Memory();
INSERT INTO
TestTable
VALUES
('2019-11-01 07:40:48', '2019-11-12 08:40:48');
SELECT *
FROM
TestTable;
SELECT
dtStart,
dtEnd,
arrayJoin(
arrayFilter(
x -> x BETWEEN dtStart AND dtEnd,
arrayConcat(
arrayMap(
x -> toDate('2019-11-01') + x,
range(toUInt32(toDate('2019-11-05') - toDate('2019-11-01')))
),
arrayMap(
x -> toDate('2019-11-10') + x,
range(toUInt32(toDate('2019-11-15') - toDate('2019-11-10')))
)
)
)
)
FROM
TestTable;
DC
SS
DC
SK
DC
TestTable
для чего? там для лежат какие-то признаки для диапазонов?DC
IS
SK
DC