Robin Moffatt • 11/1/2016

Using SQL to Query JSON Files with Apache Drill

Read Original

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
Using SQL to Query JSON Files with Apache Drill

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
Webinar Series – SQL Server Indexing
Koen Verbeeck • 1 votes
2
Risks and Limitations of AI in the Life Sciences
Jeremy Howard • 1 votes
3
1M context is now generally available for Opus 4.6 and Sonnet 4.6
Simon Willison • 1 votes
4
AI is my CMS
Chris Coyier • 1 votes
5
When your coding agent doesn’t understand your project, you’ll get junk
Benjamin Cane • 1 votes
6
LLM Use in the Python Source Code
Miguel Grinberg • 1 votes