While exploring the available operators, I found rollup and cube that turned out a more advanced variant of groupBy. It didn’t take long before I realized how much I’ve been missing without even being aware of the existence of the aggregation operators in pure SQL and now in Spark SQL.
It’s the same earth-shattering moment which I experienced after I found out about window operator.
All in all, just exploring the features of Spark SQL in Apache Spark made me better at SQL (in the databases like Hive, PostgreSQL, Microsoft SQL Server) as well as gave me some foundation on how data analysts and statisticians could use SQL and Spark SQL in their job.
Now, let’s look into what the typical IT supply chain looks like in a medium-sized company. We can accomplish this by simply listing an example of common technologies used today:
The list above is meant to paint a clearer picture of the elements in your supply chain. As you can see — even at a mid-size company — there can be a great deal of complexity and a lot of elements that defy tight control. (For deeper exploration, here is a great website dedicated to information about all things supply chain.)