Ben Chuanlong Du's Blog

It is never too late to learn.

Ignore Nulls in the Analytical Window Function Lead in SQL

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

The analytical window function lead does not support ignoring NULL values. One workaround is to to use the analytical window fucntion first_value which supports ignoring NULL values.

first_value(my_col IGNORE NULLS …

Tips on OpenFaaS

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

Tutorials

https://blog.alexellis.io/quickstart-openfaas-cli/

https://www.youtube.com/watch?time_continue=6&v=LQa8-JvIeWA&feature=emb_logo

Deploy OpenFaaS with Kubernetes

Deploy OpenFaaS from static YAML, via helm, or via new …