SQL
-
Software Development
Apache Drill SQL Queries on Parquet Data
In this week’s Whiteboard Walkthrough Parth Chandra, Chair of PMC for Apache Drill project and member of MapR engineering team,…
Read More » -
Software Development
How to remove duplicate rows from a table in SQL
There are a couple of ways to remove duplicate rows from a table in SQL e.g. you can use a…
Read More » -
Software Development
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 » -
Software Development
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 » -
Software Development
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 » -
Software Development
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 » -
Software Development
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 » -
Software Development
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 » -
Software Development
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 »
