periscopedata / redshift-udfs Goto Github PK
View Code? Open in Web Editor NEWSQL for many helpful Redshift UDFs, and the scripts for generating and testing those UDFs
License: MIT License
SQL for many helpful Redshift UDFs, and the scripts for generating and testing those UDFs
License: MIT License
Looks like last commit here was in 2016. Is this project still used an maintained by Periscope?
We use this project at Simple, although we don't have to interact with it much since we rarely define new UDFs.
We may start using UDFs more now that UDFs in SQL are available and perform better than the python versions. We may start looking more into that and I'd be interested to hear if others are relying on this project and would want to work together on adding support for SQL UDFs.
I don't see why we set the volatility of all UDFs to stable
instead of immutable
here: https://github.com/PeriscopeData/redshift-udfs/blob/master/udf_harness.rb#L108
The Redshift documentation says this:
http://docs.aws.amazon.com/fr_fr/redshift/latest/dg/r_CREATE_FUNCTION.html
According to Amazon Redshift Documentation, creating aggregate functions like the below example are not publicly available features. This repository is throwing errors and fails the tests.
http://docs.aws.amazon.com/redshift/latest/dg/udf-creating-a-scalar-udf.html
Example failing construct.
create aggregate second_max (float)
(
initfunc = agg_init_blank_varchar,
aggfunc = agg_agg_numbers_to_list,
finalizefunc = agg_finalize_second_max
);
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.