blob: 4bfbc624dc71c82795f524aed18a5a5468378fad (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
|
# frozen_string_literal: true
module ClickHouse
# This class implements a batch iterator which can be used for ClickHouse database tables.
# The batching logic uses fixed id ranges because that's the only way to efficiently batch
# over the data. This is similar to the implementation of the Gitlab::Database::BatchCount
# utility class.
#
# Usage:
#
# connection = ClickHouse::Connection.new(:main)
# builder = ClickHouse::QueryBuilder.new('event_authors')
# iterator = ClickHouse::Iterator.new(query_builder: builder, connection: connection)
# iterator.each_batch(column: :author_id, of: 100000) do |scope|
# puts scope.to_sql
# puts ClickHouse::Client.select(scope.to_sql, :main)
# end
#
# If your database table structure is optimized for a specific filter, you could scan smaller
# part of the table by adding more condition to the query builder. Example:
#
# builder = ClickHouse::QueryBuilder.new('event_authors').where(type: 'some_type')
class Iterator
# rubocop: disable CodeReuse/ActiveRecord -- this is a ClickHouse query builder class usin Arel
def initialize(query_builder:, connection:)
@query_builder = query_builder
@connection = connection
end
def each_batch(column: :id, of: 10_000)
min_max_query = query_builder.select(
table[column].minimum.as('min'),
table[column].maximum.as('max')
)
row = connection.select(min_max_query.to_sql).first
return if row.nil?
min_value = row['min']
max_value = row['max']
return if max_value == 0
loop do
break if min_value > max_value
yield query_builder
.where(table[column].gteq(min_value))
.where(table[column].lt(min_value + of))
min_value += of
end
end
private
delegate :table, to: :query_builder
attr_reader :query_builder, :connection
# rubocop: enable CodeReuse/ActiveRecord
end
end
|