Abstract: The capabilities of individual nodes that process a query may be evaluated to perform query planning. An operation of a plan to perform a query can be identified for assignment to a node based on the capabilities of nodes to perform the query operation. A node may be selected based on the difference between the selected node's capability to perform the query operation and other nodes capabilities to perform the operation. Capability-based selection can be performed at runtime, in some embodiments, in order to make query operation assignments based on further information obtained as a result of performing prior operations in the query.

Abstract: Techniques for multi-tenant storage for analytics with push down filtering are described. A multi-tenant storage service can include resources can be grouped into racks, with each rack providing a distinct endpoint to which client services may submit queries. Each rack may include interface nodes and storage nodes. The interface nodes can preprocess queries that are received by splitting them into chunks to be executed by the storage nodes. Each storage node includes a field programmable gate array (FPGA) and a CPU. The CPU can receive the operations and convert the operations into instructions that can be executed by the FPGA. The instructions may include pointers to data and operations for the FPGA to perform on the data. The FPGA can process the data stream and return the results of the processing which are returned via the interface node.