maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #12833
Pushing down aggregation functions
-
To:
"maria-developers@xxxxxxxxxxxxxxxxxxx" <maria-developers@xxxxxxxxxxxxxxxxxxx>
-
From:
"Berrocal, Eduardo" <eduardo.berrocal@xxxxxxxxx>
-
Date:
Wed, 4 Aug 2021 17:48:37 +0000
-
Accept-language:
en-US
-
Arc-authentication-results:
i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=intel.com; dmarc=pass action=none header.from=intel.com; dkim=pass header.d=intel.com; arc=none
-
Arc-message-signature:
i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=gJDh3jJqXpBECKMHlYQTNbjSQlwVs75x8EYSN61utUc=; b=TdxyMMYkcyfR7qJu1zAZ+MN6fBzYxcLFQbHrsdmC9bQOpcMa0qhFM1lF1AAx1F9RnHBnxa33GztcUNVrRnKjATqYkId5kkaNuMEElPgaemS5WiLc02A+xlUyCAsZc2cm14Hqk618+2s74TXkh2S49q/I/DxHlojMcr3rj28BdCCp/fqdiitW5idZ6AaKsWYWmvTUNrNPxAaGZg4OlXFCbcJt5EqrW9eUjkkankNMqaLgmHz7xxwOCsqqlmfjT/wF4pyYwyhoABQLWV7joBUc3TfpCALB0HInprpfhucN9Y4eYs8wufx9+Z+3vPEhncFSnjdid1OHZFhgeItK7LFFbQ==
-
Arc-seal:
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=gBX3HBTnoN8vtO52RzoxBwKe217AUDvPiGA0xp/bSMbT3SjuBLCxqYHYhpq6UqLxtYnZxHc4jOw+fSTqWge1bHNvazianeO0t3DJtJcUBMb/XMuhDvjtL1o2uHzqIvVmKMSoPv3ipZ7KpqseUxyeVH9bRbPBPndt5ltgKqfbML8FOK9fNXHVt0g+PjLu8pPr6qauNoigmqGSzfheAGspN9eF2i2kkvVHgseP78/fxia4A2mKm3dVD7SC1lNFHrbUx3/VwaSLF/DVMStABWhjqmZAF174H5vOzfC1jrN90oEywOa8g+nxufUIihO16KwpUv6t5NeKJrq3Uhqnoj01aw==
-
Authentication-results:
lists.launchpad.net; dkim=none (message not signed) header.d=none;lists.launchpad.net; dmarc=none action=none header.from=intel.com;
-
Dlp-product:
dlpe-windows
-
Dlp-reaction:
no-action
-
Dlp-version:
11.5.1.3
-
Thread-index:
AdeJV3waYKS86f09QRyNjbA89V6mUg==
-
Thread-topic:
Pushing down aggregation functions
Hello!,
Continuing in my series of emails about engine condition pushdown... I wonder if it is possible to push down aggregation functions such as SUM(), MIN(), MAX() or AVG() to the storage engine. Currently, and as far as I can see (I may be wrong here), it is not possible. However, this is something that can be beneficial if the storage engine can perform some of these basic computations itself, like suming over a whole column and returning just the result. The storage engine can even be smart enough to use some hardware advantages like accelerators or computational storage.
If you guys think this is indeed possible without drastic code changes, it would be amazing to be pointed at where this is. At first, I would only push down functions if they operate over just one column of the same table. Things can be made more complicated in the future, of course.
Thanks a lot!,
Eduardo.
Follow ups
