Hive/SQL

Using Stored Procedures in SQL (MySQL)

Stored Procedures seem in many respects quite similar to functions in SQL. However, they do have different use-cases.…

User defined functions are incredibly useful in SQL (or any language for that matter). They give us a…

When I first started using Postgres, I made the mistake of thinking it was identical to other SQL-like…

Hive, in my experience, is a platform which can have extremely variable performance, which can make it difficult…

This is a super short & quick article about keeping your queries as readable and performant as possible…

Working with dates is one of those tedious things we frequently come across as data engineers. The frustration…

Windowing functions in Hive are super useful. They make analysis that would otherwise be challenging, much easier. Let’s…

SQL is one of the most in-demand data skills. The language has been adopted by many database platforms,…