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
redshift-udfs's People
Contributors
Stargazers
Watchers
Forkers
ericfe miike gkmlo michael-erasmus civisanalytics kellyburdine rfroetscher ekta1007 cmdavis4 praveen-symphony pgoel92 mbaroudi pariyat legalbase antoineaugusti saidimu findhotel mmmaia kenarchersf niedfelj rkeable rstuczynski ben-dearmond-procore kmdpartners vergenzt srikanth4075 amico1234redshift-udfs's Issues
Switch from stable to immutable
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
Project status
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.
Aggregate functions not supported
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
);
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.