Category: Apache Drill
Everything filed under Apache Drill.
Painless ODBC + dplyr Connections to Amazon Athena and Apache Drill with R & odbc
I spent some time this morning upgrading the JDBC driver (and changing up some supporting code to account for changes to it) for my metis package? which connects R up to Amazon Athena via RJDBC. I'm used to JDBC and have to deal with Java…
R⁶ Series — Random Sampling From Apache Drill Tables With R & sergeant
At work-work I mostly deal with medium-to-large-ish data. I often want to poke at new or existing data sets w/o working across billions of rows. I also use Apache Drill for much of my exploratory…
Increasing Output Buffer Size in Apache Drill UDFs Custom (Simple) Functions
Putting this here to make it easier for others who try to Google this topic to find it w/o having to find and tediously search through other UDFs (user-defined…
Reading PCAP Files with Apache Drill and the sergeant R Package
It's no secret that I'm a fan of Apache Drill . One big strength of the platform is that it normalizes the access to diverse data sources down to ANSI SQL calls, which means that I can pull data from parquet, Hie, HBase, Kudu, CSV, JSON,…
Ten-HUT! The Apache Drill R interface package — sergeant — is now on CRAN
I'm extremely pleased to announce that the sergeant package is now on CRAN or will be hitting your local CRAN mirror…
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…
Drilling Into CSVs — Teaser Trailer
I used reading a directory of CSVs as the foundational example in my recent post on idioms…
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…