Browsing Category
Hive/SQL
8 posts
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.…
Implement User Defined Functions in SQL (MySQL)
User defined functions are incredibly useful in SQL (or any language for that matter). They give us a…
Basic PostgreSQL commands you need to know
When I first started using Postgres, I made the mistake of thinking it was identical to other SQL-like…
Parameters to make your Hive queries perform better
Hive, in my experience, is a platform which can have extremely variable performance, which can make it difficult…
Keeping your Hive queries clean with CTEs
This is a super short & quick article about keeping your queries as readable and performant as possible…
Working with dates in Apache Hive
Working with dates is one of those tedious things we frequently come across as data engineers. The frustration…
A guide to windowing functions in Hive for data analysis
Windowing functions in Hive are super useful. They make analysis that would otherwise be challenging, much easier. Let’s…
The Hive SQL Crash Course For Data Analysts
SQL is one of the most in-demand data skills. The language has been adopted by many database platforms,…