Parallelizing SQL user defined transformation functions

A method for parallelizing structured query language (SQL) user defined transformation functions, the method comprising:

• processing, by a processor of a computing device, a query to obtain a plurality of subqueries, wherein each of the plurality of subqueries is associated with a magic number of a plurality of distinct magic numbers in a magic table, and wherein the plurality of distinct magic numbers in the magic table are used to trigger a plurality of database nodes in a database system to execute the plurality of subqueries in parallel;
• inserting, by the processor, the plurality of distinct magic numbers into the plurality of subqueries associated with the plurality of distinct magic numbers;
• sending, by the processor, each of the plurality of subqueries to one of the plurality of database nodes, wherein the plurality of database nodes are caused to detect the plurality of distinct magic numbers in the plurality of subqueries and, in response to detecting the plurality of distinct magic numbers, execute the plurality of subqueries in parallel to obtain data from local databases of the plurality of database nodes;
• and
• in response to receiving a plurality of results from the plurality of database nodes for the plurality of subqueries, unioning, by the processor, the plurality of results to generate a dataset for the query.

A non-transitory machine-readable storage medium storing instructions executable by a processor for parallelizing structured query language (SQL) user defined transformation functions, wherein the instructions are executable to cause the processor to:

• process a query to obtain a plurality of subqueries, wherein each of the plurality of subqueries is associated with a magic number of a plurality of distinct magic numbers in a magic table, and wherein the plurality of distinct magic numbers in the magic table are used to trigger a plurality of database nodes in a database system to execute the plurality of subqueries in parallel;
• insert the plurality of distinct magic numbers into the plurality of subqueries associated with the plurality of distinct magic numbers;
• send each of the plurality of subqueries to one of the plurality of database nodes, wherein the plurality of database nodes are caused to detect the plurality of distinct magic numbers in the plurality of subqueries and, in response to detecting the plurality of distinct magic numbers, execute the plurality of subqueries in parallel using a local, role-based version of a user defined transformation function to obtain data from local databases of the plurality of database nodes;
• and
• in response to receiving a plurality of results from the plurality of database nodes for the plurality of subqueries, union the plurality of results to generate a dataset for the query.