Processing user-defined functions (UDFs) using multiple execution environments

1. A method comprising:

detecting, by at least one hardware processor, an upload of a user application within a database system, the user application comprising user-defined function (UDF) code;

determining, by the at least one hardware processor, a plurality of dependencies of the user application;

generating, by the at least one hardware processor, a plurality of execution environments corresponding to the plurality of dependencies, the plurality of execution environments associated with a corresponding plurality of data types of the UDF;

decoding a database query, the database query specifying database data of a data type of the plurality of data types of the UDF; and

processing the database query using at least one of the plurality of execution environments to generate results data, the at least one of the plurality of execution environments corresponding to the data type of the plurality of data types of the UDF.

2. The method of claim 1 , further comprising:

determining one or more of at least one software package, a code version, and a code library associated with the UDF code to determine the plurality of dependencies.

3. The method of claim 1 , further comprising:

instantiating a first execution process within a computing node of the database system.

4. The method of claim 3 , further comprising:

configuring a plurality of UDF clients within the first execution process, the plurality of UDF clients corresponding to the plurality of execution environments.

5. The method of claim 4 , further comprising:

selecting a UDF client of the plurality of UDF clients based on the data type of the database query.

6. The method of claim 5 , further comprising:

forwarding using the UDF client, the database query to an execution environment of the plurality of execution environments to generate the results data, the execution environment corresponding to the UDF client.

7. The method of claim 6 , further comprising:

reformatting the database data specified by the database query using a data transport mechanism of the UDF client to generate reformatted data, the reformatted data comprising columnar data; and

forwarding the columnar data to the execution environment, the result data based on the columnar data.

8. The method of claim 4 , further comprising:

instantiating a second execution process within the computing node of the database system; and

instantiating a user code runtime within the second execution process.

9. The method of claim 8 , further comprising:

instantiating the plurality of execution environments corresponding to the plurality of dependencies as UDF server processes within the user code runtime.

10. The method of claim 8 , further comprising:

instantiating the second execution process as a sandbox process within the computing node.

11. A system comprising:

at least one hardware processor; and

at least one memory storing instructions that cause the at least one hardware processor to perform operations comprising:

detecting an upload of a user application within a database system, the user application comprising user-defined function (UDF) code;

determining a plurality of dependencies of the user application;

generating a plurality of execution environments corresponding to the plurality of dependencies, the plurality of execution environments associated with a corresponding plurality of data types of the UDF;

decoding a database query, the database query specifying database data of a data type of the plurality of data types of the UDF; and

processing the database query using at least one of the plurality of execution environments to generate results data, the at least one of the plurality of execution environments corresponding to the data type of the plurality of data types of the UDF.

12. The system of claim 11 , the operations further comprising:

determining one or more of at least one software package, a code version, and a code library associated with the UDF code to determine the plurality of dependencies.

13. The system of claim 11 , the operations further comprising:

instantiating a first execution process within a computing node of the database system.

14. The system of claim 13 , the operations further comprising:

configuring a plurality of UDF clients within the first execution process, the plurality of UDF clients corresponding to the plurality of execution environments.

15. The system of claim 14 , the operations further comprising:

selecting a UDF client of the plurality of UDF clients based on the data type of the database query.

16. The system of claim 15 , the operations further comprising:

forwarding using the UDF client, the database query to an execution environment of the plurality of execution environments to generate the results data, the execution environment corresponding to the UDF client.

17. The system of claim 16 , the operations further comprising:

reformatting the database data specified by the database query using a data transport mechanism of the UDF client to generate reformatted data, the reformatted data comprising columnar data; and

forwarding the columnar data to the execution environment, the result data based on the columnar data.

18. The system of claim 14 , the operations further comprising:

instantiating a second execution process within the computing node of the database system; and

instantiating a user code runtime within the second execution process.

19. The system of claim 18 , the operations further comprising:

instantiating the plurality of execution environments corresponding to the plurality of dependencies as UDF server processes within the user code runtime.

20. The system of claim 18 , the operations further comprising:

instantiating the second execution process as a sandbox process within the computing node.

21. A computer-storage medium comprising instructions that, when executed by one or more processors of a machine, configure the machine to perform operations comprising:

detecting an upload of a user application within a database system, the user application comprising user-defined function (UDF) code;

determining a plurality of dependencies of the user application;

generating a plurality of execution environments corresponding to the plurality of dependencies, the plurality of execution environments associated with a corresponding plurality of data types of the UDF;

decoding a database query, the database query specifying database data of a data type of the plurality of data types of the UDF; and

processing the database query using at least one of the plurality of execution environments to generate results data, the at least one of the plurality of execution environments corresponding to the data type of the plurality of data types of the UDF.

22. The computer-storage medium of claim 21 , the operations further comprising:

determining one or more of at least one software package, a code version, and a code library associated with the UDF code to determine the plurality of dependencies.

23. The computer-storage medium of claim 21 , the operations further comprising:

instantiating a first execution process within a computing node of the database system.

24. The computer-storage medium of claim 23 , the operations further comprising:

configuring a plurality of UDF clients within the first execution process, the plurality of UDF clients corresponding to the plurality of execution environments.

25. The computer-storage medium of claim 24 , the operations further comprising:

selecting a UDF client of the plurality of UDF clients based on the data type of the database query.

26. The computer-storage medium of claim 25 , the operations further comprising:

forwarding using the UDF client, the database query to an execution environment of the plurality of execution environments to generate the results data, the execution environment corresponding to the UDF client.

27. The computer-storage medium of claim 26 , the operations further comprising:

reformatting the database data specified by the database query using a data transport mechanism of the UDF client to generate reformatted data, the reformatted data comprising columnar data; and

forwarding the columnar data to the execution environment, the result data based on the columnar data.

28. The computer-storage medium of claim 24 , the operations further comprising:

instantiating a second execution process within the computing node of the database system; and

instantiating a user code runtime within the second execution process.

29. The computer-storage medium of claim 28 , the operations further comprising:

instantiating the plurality of execution environments corresponding to the plurality of dependencies as UDF server processes within the user code runtime.

30. The computer-storage medium of claim 28 , the operations further comprising:

instantiating the second execution process as a sandbox process within the computing node.