System and method for distributed query execution with worker nodes operating different software versions

A method for distributed query execution via query federation using semantic model query plans, comprising:

• providing, at a computer system including one or more processors, a cloud or data analytics environment comprising a semantic layer that includes a semantic model of a customer's data, and operating as a federated query engine to serve analytical queries or requests from clients directed to data stored at a database;
• wherein the system maintains a query engine feature table that includes information indicating, for each query engine node of a plurality of query engine nodes, the features provided by that query engine node;
• wherein the information provided by the query engine feature table is used during query planning so that a query engine node operating as a master node can obtain a list of nodes hosting particular semantic models and supporting particular features or query operators;
• and
• in response to a query associated with one or more software environments, software versions, or semantic models:
• determining, based on the information provided by the query engine feature table, which query engine nodes support requested semantic model features or query operators, and
• generating a composite query execution plan that controls distribution of query portions to a subset of worker nodes that support those features or query operators;
• wherein portions of the query are distributed to the concurrently-running query engines for parallel execution or processing.

A non-transitory computer readable storage medium, including instructions stored thereon which when read and executed by one or more computers cause the one or more computers to perform a method comprising:

• providing, at a computer system including one or more processors, a cloud or data analytics environment comprising a semantic layer that includes a semantic model of a customer's data, and operating as a federated query engine to serve analytical queries or requests from clients directed to data stored at a database;
• wherein the system maintains a query engine feature table that includes information indicating, for each query engine node of a plurality of query engine nodes, the features provided by that query engine node;
• wherein the information provided by the query engine feature table is used during query planning so that a query engine node operating as a master node can obtain a list of nodes hosting particular semantic models and supporting particular features or query operators;
• and
• in response to a query associated with one or more software environments, software versions, or semantic models:
• determining, based on the information provided by the query engine feature table, which query engine nodes support requested semantic model features or query operators, and
• generating a composite query execution plan that controls distribution of query portions to a subset of worker nodes that support those features or query operators;
• wherein portions of the query are distributed to the concurrently-running query engines for parallel execution or processing.