Distributing partial results to worker nodes from an external data system
Systems and methods are disclosed for executing a query that includes an indication to process data managed by an external data system. The system identifies the external data system that manages the data to be processed, and generates a subquery for the external data system indicating that the results of the subquery are to be sent to multiple worker nodes. The system also generates instructions for multiple worker nodes to receive and process results of the subquery from the external data system.
1. A method, comprising:
receiving, at a data intake and query system, a query identifying a set of data to be processed and a manner of processing the set of data;
determining that the set of data includes at least a subset of data associated with an external data system;
defining, by the data intake and query system, a query processing scheme for obtaining and processing the set of data, wherein defining the query processing scheme comprises:
determining a subquery for the external data system, the subquery identifying the at least a subset of data and a manner of processing the at least a subset of data and instructing the external data system to distribute results of the subquery to a plurality of worker nodes, and
generating instructions for the plurality of worker nodes to receive and process the results of the subquery to form processed results and to provide the processed results to the data intake and query system; and
executing the query based on the query processing scheme, wherein the data intake and query system and the external data system each independently execute queries other than the query.
2. The method of claim 1 , wherein executing the query comprises communicating the subquery to a search head of the external data system for execution.
3. The method of claim 1 , wherein executing the query comprises communicating the subquery to the external data system, wherein the external data system executes the subquery and streams the results of the subquery to the plurality of worker nodes without storing the results of the subquery to disk.
4. The method of claim 1 , wherein executing the query comprises communicating the subquery to a search head of the external data system, wherein the search head executes the subquery and streams the results of the subquery to the plurality of worker nodes.
5. The method of claim 1 , wherein executing the query comprises communicating the subquery to the external data system, wherein the external data system executes the subquery and streams the results of the subquery to the plurality of worker nodes from one or more indexers of the external data system.
6. The method of claim 1 , wherein the at least a subset of data is a second subset of data, and the processed results are second processed results, the method further comprising:
determining that the set of data includes a first subset of data associated with the data intake and query system,
wherein defining the query processing scheme, further comprises:
generating a subquery for the data intake and query system, the subquery for the data intake and query system identifying the first subset of data and a manner of processing the first subset of data, and
generating instructions for one or more worker nodes of the plurality of worker nodes to receive and process results of the subquery for the data intake and query system to form first processed results and to provide the first processed results to the data intake and query system.
7. The method of claim 1 , wherein the at least a subset of data is a second subset of data, and the processed results are second processed results, the method further comprising:
determining that the set of data includes a first subset of data associated with the data intake and query system,
wherein defining the query processing scheme, further comprises:
generating a subquery for the data intake and query system, the subquery for the data intake and query system identifying the first subset of data and a manner of processing the first subset of data,
determining a first data ingest estimate based on the subquery for the data intake and query system and a second data ingest estimate based on the subquery for the external data system, and
generating, based on the first data ingest estimate, instructions for one or more worker nodes of the plurality of worker nodes to receive and process results of the subquery for the data intake and query system to form first processed results and to provide the first processed results and the second processed results to the data intake and query system,
wherein the instructions for the plurality of worker nodes to receive and process results of the subquery for the external data system are generated based on the second data ingest estimate.
8. The method of claim 1 , wherein the at least a subset of data is a second subset of data, and the processed results are second processed results, the method further comprising:
determining that the set of data includes a first subset of data associated with the data intake and query system,
wherein defining the query processing scheme, further comprises:
generating a subquery for the data intake and query system, the subquery for the data intake and query system identifying the first subset of data and a manner of processing the first subset of data, and
generating instructions for one or more worker nodes of the plurality of worker nodes to receive and process results of the subquery for the data intake and query system to generate first processed results, to combine and process the first processed results and the second processed results to form combined processed results, and to provide the combined processed results to the data intake and query system.
9. The method of claim 1 , wherein the at least a subset of data is a first subset of data, the processed results are first processed results, and the external data system is a first external data system the method further comprising:
determining that the set of data includes a second subset of data associated with a second external data system,
wherein defining the query processing scheme, further comprises:
generating a subquery for the second external data system, the subquery for the second external data system identifying the second subset of data and a manner of processing the second subset of data; and
generating instructions for one or more worker nodes of the plurality of worker nodes to receive and process results of the subquery for the second external data system to form second processed results and to provide the second processed results to the data intake and query system.
10. The method of claim 1 , wherein determining that the set of data includes at least the subset of data comprises:
parsing the query;
identifying a search parameter in the query associated with a search of an external data source;
identifying the external data system based on said identifying the search parameter; and
determining access information to access the external data system.
11. The method of claim 1 , wherein determining that the set of data includes at least the subset of data comprises:
parsing the query;
identifying a search parameter in the query that includes an identification of the external data system; and
determining access information to access the external data system based on said identification of the external data system.
12. The method of claim 1 , wherein determining that the set of data includes at least the subset of data comprises:
parsing the query;
identifying a search parameter in the query associated with a search of an external data source;
parsing a configuration file based on the search parameter;
identifying the external data system based on said parsing the configuration file; and
determining access information to access the external data system based on said identifying the external data system.
13. The method of claim 1 , further comprising associating a search identifier with the external data system, wherein the plurality of worker nodes processes results of the subquery based on the search identifier.
14. The method of claim 1 , wherein
defining the query processing scheme further comprises associating, by the data intake and query system, a first search identifier with the external data system, and
executing the query comprises:
receiving, by the plurality of worker nodes, the results of the subquery, wherein the results of the subquery include a second search identifier assigned to the results of the subquery by the external data system;
mapping the first search identifier to the second search identifier; and
processing the results of the subquery based on said mapping.
15. The method of claim 1 , wherein generating instructions for the plurality of worker nodes comprises:
obtaining a data ingest estimate for the subquery; and
generating instructions for the plurality of worker nodes based on the data ingest estimate.
16. The method of claim 1 , wherein generating instructions for the plurality of worker nodes comprises:
determining a processing capability of the external data system;
determining a data ingest estimate for the subquery based on the processing capability; and
generating instructions for the plurality of worker nodes based on the data ingest estimate.
17. The method of claim 1 , wherein generating instructions for the plurality of worker nodes comprises:
assigning a worker node of the plurality of worker nodes to request a version identifier from the external data system;
receiving the version identifier from the worker node;
determining a data ingest estimate for the subquery based on the version identifier; and
generating instructions for the plurality of worker nodes based on the data ingest estimate.
18. The method of claim 1 , wherein generating instructions for the plurality of worker nodes comprises:
assigning a worker node of the plurality of worker nodes to determine a data ingest estimate for the subquery;
communicating the subquery to the worker node, wherein the worker node communicates the subquery to the external data system and receives the data ingest estimate from the external data system; and
generating instructions for the plurality of worker nodes based on the data ingest estimate.
19. The method of claim 1 , wherein generating instructions for plurality of worker nodes comprises:
assigning a worker node of the plurality of worker nodes to determine a data ingest estimate for the subquery;
communicating the subquery to the worker node, wherein the worker node parses the subquery, communicates one or more search parameters to the external data system, and receives the data ingest estimate from the external data system; and
generating instructions for the plurality of worker nodes based on the data ingest estimate.
20. The method of claim 1 , wherein generating instructions for plurality of worker nodes comprises:
determining a quantity of partitions to ingest the results of the subquery; and
generating instructions for the plurality of worker nodes based on the quantity of partitions.
21. The method of claim 1 , wherein defining the query processing scheme, further comprises:
obtaining network access information from at least one worker node of the plurality of worker nodes, wherein executing the query comprises communicating the network access information to the external data system.
22. The method of claim 1 , wherein generating the subquery comprises:
determining a processing capability of the external data system; and
generating the subquery based on the processing capability.
23. The method of claim 1 , wherein generating the subquery comprises:
assigning a worker node of the plurality of worker nodes to request a version identifier from the external data system;
receiving the version identifier from the worker node; and
generating the subquery based on the version identifier.
24. The method of claim 1 , wherein executing the query comprises:
communicating the subquery to the plurality of worker nodes, wherein at least one worker node of the plurality of worker nodes communicates the subquery to the external data system, the external data system processes and executes the subquery, and the plurality of worker nodes receive and process the results of the subquery to form the processed results; and
receiving the processed results from the plurality of worker nodes.
25. The method of claim 1 , wherein executing the query comprises:
communicating the subquery to the external data system using at least one of the plurality of worker nodes, wherein the external data system processes and executes the subquery using one or more worker nodes of the plurality of worker nodes and the plurality of worker nodes process the results of the subquery to form the processed results; and
receiving the processed results from the one or more worker nodes.
26. The method of claim 1 , wherein the subquery is generated based on search configuration data associated with the external data system.
27. A method, comprising:
receiving, at a data intake and query system, a query identifying a set of data to be processed and a manner of processing the set of data;
determining that the set of data includes at least a subset of data associated with an external data system;
defining, by the data intake and query system, a query processing scheme for obtaining and processing the set of data, wherein defining the query processing scheme comprises:
generating a subquery for the external data system, the subquery identifying the at least a subset of data and a manner of processing the at least a subset of data and instructing the external data system to distribute results of the subquery to a plurality of worker nodes, wherein the subquery is generated based on search configuration data associated with the external data system, and
generating instructions for the plurality of worker nodes to receive and process the results of the subquery to form processed results and to provide the processed results to the data intake and query system; and
executing the query based on the query processing scheme.
28. The method of claim 27 , wherein the data intake and query system and the external data system each independently receive queries other than the query, generate subqueries based on the queries, and execute the subqueries.
29. A computing system of a data intake and query system, the computing system comprising:
memory; and
one or more processing devices coupled to the memory and configured to:
receive a query identifying a set of data to be processed and a manner of processing the set of data;
determine that the set of data includes at least a subset of data associated with an external data system;
define a query processing scheme for obtaining and processing the set of data, wherein to define the query processing scheme, the one or more processing devices are configured to:
determine a subquery for the external data system, the subquery identifying the at least a subset of data and a manner of processing the at least a subset of data and instructing the external data system to distribute results of the subquery to a plurality of worker nodes, and
generate instructions for the plurality of worker nodes to receive and process the results of the subquery to form processed results and to provide the processed results to the data intake and query system; and
initiate execution of the query based on the query processing scheme, wherein the data intake and query system and the external data system each independently execute queries other than the query.
30. Non-transitory computer readable media comprising computer-executable instructions that, when executed by a computing system of a data intake and query system, cause the computing system to:
receive a query identifying a set of data to be processed and a manner of processing the set of data;
determine that the set of data includes at least a subset of data associated with an external data system;
define a query processing scheme for obtaining and processing the set of data, wherein to define the query processing scheme the computer-executable instructions cause the computing system to:
determine a subquery for the external data system, the subquery identifying the at least a subset of data and a manner of processing the at least a subset of data and instructing the external data system to distribute results of the subquery to a plurality of worker nodes, and
generate instructions for the plurality of worker nodes to receive and process the results of the subquery to form processed results and to provide the processed results to the data intake and query system; and
initiate execution of the query based on the query processing scheme, wherein the data intake and query system and the external data system each independently execute queries other than the query.