Blog

BI on Big Data: What are your options?
Jun 8, 2016

Introducing Apache Arrow: Columnar In-Memory Analytics
Feb 17, 2016

What can LIGO see? Let’s look at gravitational waves with SQL
Feb 11, 2016

Parsing EPA vehicle data for linear correlations in MPG ratings
Feb 11, 2016

Calculating Pearson’s r using a custom SQL function
Feb 10, 2016

Managing variable type nullability
Feb 9, 2016

Smartest and dumbest subreddits as judged by submission title readability
Feb 6, 2016

Querying for reading level with a simple UDF
Feb 5, 2016

The case of the stolen candy hearts: Advanced date parsing in SQL
Feb 2, 2016

Reddit hates George Bush more than Vladimir Putin
Jan 29, 2016

Writing a custom SQL function for sentiment analysis
Jan 28, 2016

Securing SQL on Hadoop, Part 2: Installing and configuring Drill
Jan 25, 2016

Securing SQL on Hadoop, Part 1: Installing CDH and Kerberos
Jan 22, 2016

Drill plays the classics: Querying musical compositions with SQL
Jan 21, 2016

Using a SQL JOIN on two CSV files
Jan 19, 2016

Converting CSV file data to Kudu storage
Jan 18, 2016

SQL on Kudu quickstart
Jan 13, 2016

Old and busted: Teasing formerly-fashionable websites from Reddit data
Jan 3, 2016

Predicting International Space Station solar transits using built-in SQL math functions
Dec 21, 2015

Tuning Parquet file performance
Dec 13, 2015

Examining U.S. radio antenna locations with Tableau Desktop 9
Dec 10, 2015

Installing Apache Drill on Microsoft Windows
Dec 8, 2015

Performing basic statistics operations on Twitter data
Dec 3, 2015

Querying dates using SQL in a JSON document
Dec 3, 2015

White mana cards are cheap and stupid: Querying a database of every Magic card ever made
Dec 3, 2015

Setting up an SQL interface to a sharded MongoDB
Dec 2, 2015

Configuring Drill’s storage plugins with the REST API
Dec 2, 2015

SQL and Parquet: A simple demo
Dec 1, 2015

Bless this mess: Working with complicated JSON structure in SQL
Dec 1, 2015

Finding corrupt JSON records in MongoDB
Nov 30, 2015

SQL queries on CSV files with column headers
Nov 23, 2015

Bootstrapping an interactive SQL environment on Amazon EMR
Nov 17, 2015

How to query S3 data using Amazon’s S3a library
Nov 16, 2015

Querying Google Analytics JSON with a custom SQL function
Oct 30, 2015

Using SQL to interface with Google Analytics data stored on Amazon S3
Oct 20, 2015

Running SQL Queries on CSV Files Using Apache Drill
Oct 13, 2015

Bringing SQL to MongoDB with Apache Drill
Sep 20, 2015