Just-in-time injection in a distributed database
A request for database results is received from a query coordinator at a database instance of a distributed database. The request includes a query execution instruction of a query plan and an indication of override instructions corresponding to the query execution instruction. The override instructions are such that they do not modify the query plan. The database instance includes the override instructions in a set of high-level language query instructions. The database instance performs just-in-time compiling of the set of high-level language query instructions to obtain a machine language query for performing the query execution instruction of the query plan. The database instance executes the machine language query to obtain the database results. The database instance then transmits the database results to the query coordinator.
1. A method, comprising:
receiving, from a query coordinator at a database instance of a distributed database, a request for database results, wherein the request comprises a query execution instruction of a query plan and an indication of override instructions corresponding to the query execution instruction, wherein the override instructions do not modify the query plan, wherein the query execution instruction comprises structured query language (SQL), and wherein the override instructions are indicative of first source code instructions written in a high-level programming language that is not SQL;
including, by the database instance, the override instructions in a set of high-level language query instructions, where the high-level language query instructions are second source code instructions written in the high-level programming language;
performing, by the database instance, just-in-time compiling of the set of high-level language query instructions to obtain a machine language query for performing the query execution instruction of the query plan;
executing, by the database instance, the machine language query to obtain the database results; and
transmitting, by database instance, the database results to the query coordinator.
2. The method of claim 1 , wherein the query plan is generated at the query coordinator of the distributed database.
3. The method of claim 1 ,
wherein the query execution instruction is a first query execution instruction,
wherein the request further comprises a second query execution instruction of the query plan, and
wherein the method further comprises:
responsive to determining that the request does not include an indication of override instructions for the second query execution instruction, including default high-level language query instructions for the second query execution instruction in the set of high-level language query instructions.
4. The method of claim 1 , wherein the indication of the override instructions comprises a file name.
5. The method of claim 1 , wherein the indication of the override instructions comprises a string containing source high-level language query instructions.
6. The method of claim 1 , wherein the indication of the override instructions comprises a directive to override the query execution instruction.
7. The method of claim 1 , wherein the database instance is a clone of another database instance of the distributed database, and wherein the database instance shares a memory space of the other database instance.
8. The method of claim 7 , wherein the memory space is shared in read-only mode.
9. A system, comprising:
a memory; and
a processor, the processor configured to executed instructions stored in the memory to:
receive, from a query coordinator, a request for database results, wherein the request comprises a query execution instruction of a query plan and an indication of override instructions corresponding to the query execution instruction, wherein the override instructions do not modify the query plan, wherein the query execution instruction comprises structured query language (SQL), and wherein the override instructions are indicative of first source code instructions written in a high-level programming language that is not SQL;
include override instructions in a set of high-level language query instructions, wherein the high-level language query instructions are second source code instructions written in the high-level programming language;
perform just-in-time compiling of the set of high-level language query instructions to obtain a machine language query for performing the query execution instruction of the query plan;
execute the machine language query to obtain the database results; and
transmit the database results to the query coordinator.
10. The system of claim 9 , wherein the query plan is generated at the query coordinator of a distributed database.
11. The system of claim 9 ,
wherein the query execution instruction is a first query execution instruction,
wherein the request further comprises a second query execution instruction of the query plan, and
wherein the processor is further configured to execute instructions stored in the memory to:
include default high-level language query instructions for the second query execution instruction in the set of high-level language query instructions.
12. The system of claim 9 , wherein the indication of the override instructions comprises a file name.
13. The system of claim 9 , wherein the indication of the override instructions comprises a string containing source high-level language query instructions.
14. The system of claim 9 , wherein the indication of the override instructions comprises a directive to override the query execution instruction.
15. The system of claim 9 , wherein the processor is further configured to execute instructions stored in the memory to:
clone a database instance of a distributed database; and
share a memory space of the database instance in read-only mode.
16. A non-transitory computer readable medium storing instructions operable to cause one or more processors to perform operations comprising:
receiving, from a query coordinator at a database instance of a distributed database, a request for database results, wherein the request comprises a query execution instruction of a query plan and an indication of override instructions corresponding to the query execution instruction, wherein the override instructions do not modify the query plan, wherein the query execution instruction comprises structured query language (SQL), and wherein the override instructions are indicative of first source code instructions written in a high-level programming language that is not SQL;
including, by the database instance, the override instructions in a set of high-level language query instructions, wherein the high-level language query instructions are second source code instructions written in the high-level programming language;
performing, by the database instance, just-in-time compiling of the set of high-level language query instructions to obtain a machine language query for performing the query execution instruction of the query plan;
executing, by the database instance, the machine language query to obtain the database results; and
transmitting, by database instance, the database results to the query coordinator.
17. The non-transitory computer readable medium of claim 16 ,
wherein the query execution instruction is a first query execution instruction,
wherein the request further comprises a second query execution instruction of the query plan, and
wherein the operations further comprise:
responsive to determining that the request does not include an indication of override instructions for the second query execution instruction, including default high-level language query instructions for the second query execution instruction in the set of high-level language query instructions.
18. The non-transitory computer readable medium of claim 16 , wherein the indication of the override instructions comprises a file name.
19. The non-transitory computer readable medium of claim 16 , wherein the indication of the override instructions comprises a string containing source high-level language query instructions.
20. The non-transitory computer readable medium of claim 16 , wherein the indication of the override instructions comprises a directive to override the query execution instruction.