G
Size: a a a
G
S
G
G
S
S
AP
S
AP
G
DD
SELECT *
FROM (
SELECT *
FROM (
SELECT
shard_num AS LocalShard,
*
FROM distributed_table
INNER JOIN system.clusters ON is_local = materialize(1) AND cluster = materialize(‘xxx’)
WHERE Action IN (
'click',
'transition'
)
AND ActionDate >= today() - 5
AND ActionCode GLOBAL IN (SELECT ActionCode FROM local_table)
ORDER BY ActionAt, LocalShard
LIMIT 1 BY ActionCode
)
GLOBAL ALL INNER JOIN (
SELECT * FROM local_table
) USING (ActionCode, BannerID, SpotID)
LIMIT 1 BY ActionCode, LeadActionCode, BannerID, SpotID
)
Error running query: Code: 171, e.displayText() = DB::Exception: Cannot convert column 1 because it is non constant in source stream but must be constant in result (version 19.16.14.65 (official build))
S
DC
VB
DC
VB
DC
Д
DC
VB
max_server_memory_usage_to_ram_ratio
?