Using Apache Spark SQL to Explore S&P 500, and Oil Stock Prices

This post will use Apache Spark SQL and DataFrames to query, compare and explore S&P 500, Exxon and Anadarko Petroleum…

Read More »

SQL Query on Mixed Schema Data Using Apache Drill

You may have heard this statement before:      Apache Drill does schema discovery on-the-fly. What does that mean, and why should…

Read More »

SQL for Application Developers

“SQL? Isn’t that just something my ORM tools use?” Often application developers can and should remain at least one level…

Read More »

Correlated Subqueries are Evil and Slow. Or are They?

A common myth in SQL is the idea that correlated subqueries are evil and slow. For example, this query here:…

Read More »

NetBeans SQL Profiler – Take it for a Spin!

The upcoming release of NetBeans, currently in active development and testing, boasts plenty of new features.  A few of them…

Read More »

10 SQL Tricks That You Didn’t Think Were Possible

Listicles like these do work – not only do they attract attention, if the content is also valuable (and in…

Read More »

Time for some Funky SQL: Prefix Sum Calculation

This Stack Overflow question has yet again nerd-sniped me: [finding the] maximum element in the array that would result from…

Read More »

Apache Spark as a Distributed SQL Engine

SQL has been here for awhile and people like it. However, the engines that power SQL have changed with time…

Read More »

10 Easy Steps to a Complete Understanding of SQL

Too many programmers think SQL is a bit of a beast. It is one of the few declarative languages out…

Read More »