Amazon Web Service has announced that Amazon RedShift has
now added SQL Scalar User Defined Functions. By utilizing the PostgreSQL syntax
you can build the custom SQL scalar functions and perform them at the parallel
on the clusters. Replacing the SQL Function name with the SQL Function code on
the leader note you increase the performance and running this as a regular SQL parallel
on every node of the cluster. Once you have created and customised you can then
rename or name such scalar UDFs in any SQL Statement.
No comments:
Post a Comment