Queries based on ranges of hash values

A computing system comprising:

• a processor;
• and
• a memory storing instructions that when executed cause the processor to:
• receive a query that includes a particular range of hash values;
• determine that the particular range of hash values in the query is a same as a range of hash values of a table partition stored in a first node of a plurality of nodes of a distributed database and is not the same as ranges of hash values of table partitions stored in other nodes of the distributed database;
• responsive to the determination that the particular range of hash values in the query is the same as the range of hash values of the table partition stored in the first node and is not the same as the ranges of hash values of the table partitions stored in the other nodes, generate an optimized distributed execution plan that includes only the first node and excludes the other nodes from executing the optimized distributed execution plan;
• and
• execute the optimized distributed execution plan on the table partition stored in the first node to generate data requested by the query, without sending the optimized distributed execution plan to the other nodes for execution.

A non-transitory computer-readable storage medium including instructions stored thereon that, when executed, cause a processor to:

• receive a query that includes a particular range of hash values;
• determine that the particular range of hash values in the query is a same as a range of hash values of a table partition stored in a first node of a plurality of nodes of a distributed database and is not the same as ranges of hash values of table partitions stored in other nodes of the distributed database;
• responsive to the determination that the particular range of hash values in the query is the same as the range of hash values of the table partition stored in the first node and is not the same as the ranges of hash values of the table partitions stored in the other nodes, generate an optimized distributed execution plan that includes only the first node and excludes the other nodes from executing the optimized distributed execution plan;
• and
• execute the optimized distributed execution plan on the table partition stored in the first node to generate data requested by the query, without sending the optimized distributed execution plan to the other nodes for execution.