Robin Moffatt • 11/1/2016

Using SQL to Query JSON Files with Apache Drill

This technical article demonstrates how to use Apache Drill, a SQL query engine, to directly query JSON data files. It walks through a real-world use case of analyzing blog traffic by author by joining data from Google Analytics with author information extracted from a Ghost platform JSON export using SQL queries.

0 comments

#json #sql #data analysis