java - 使用 ExecutorService 计算 mysql 表上的 sum()

Question

我有一个包含大量行的 MySQL 表。我有一个查询计算每个单独列的 sum()。我正在使用限制偏移量来分隔为部分。我需要使用 java ExecutorService 线程池并行处理这些部分。最后从每个部分获取所有总和值，并将它们全部添加到每一列。

让选择语句像。

select sum(principal_amount) as total_principal_amount, sum(interest_amount) as total_interest_amount from X limit 1000 offset 0.

select sum(principal_amount) as total_principal_amount, sum(interest_amount) as total_interest_amount from X limit 1000 offset 1000.

select sum(principal_amount) as total_principal_amount, sum(interest_amount) as total_interest_amount from X limit 1000 offset 2000.

标签： javamysqlexecutorservice