Category: SQL
Everything filed under SQL.
Keeping Track Of URLs Shared On Bluesky
While the future of Bluesky is nowhere near certain, it is most certainly growing. It's also the largest community of users for the AT…
New Apache Drill UDF for Processing Twitter Tweet Text
There are many ways to gather Twitter data for analysis and many R and Python (et al) libraries make full use of the Twitter API when building a corpus to extract useful metadata for each tweet along with the text of each tweet. However,…
Replicating the Apache Drill 'Yelp' Academic Dataset Analysis with sergeant
The Apache Drill folks have a nice walk-through tutorial on how to analyze the Yelp Academic Dataset with Drill . It's a bit out of date (the current Yelp data set structure is different enough that the tutorial will error out at various…
Create Parquet Files From R Data Frames With sergeant & Apache Drill (a.k.a. Make Parquet Files Great Again in R)
When you're in this larger-data world, parquet files are one of the core data storage formats. They're designed to be compact and are optimized for columnar operations. Unlike CSV, JSON files or even R Data files, it's not necessary to…
sergeant : An R Boot Camp for Apache Drill
I recently mentioned that I've been working on a development version of an Apache Drill R package called sergeant . Here's a lifted "TLDR" on…