Vince Gonzalez

  • Splitting nested strings in JSON in Apache Drill

    What do you do when you get a comma-delimited list in a column of some data you want to query in drill?

  • Bootstrapping MapR Cluster Nodes in EC2

    There’s a bunch of ways to spin up MapR in AWS. Primarily, I use ansible to do it. Why spin up instances and install them myself? Mainly it’s because I’m not always using AWS, and I need a repeatable way to install clusters under any circumstance, whether on-prem or cloud.

  • User On-Boarding Basics with MapR

    MapR FS provides some very useful capabilities for data management and access control. These features can and should be applied to user home directories.

  • Submitting Drill queries from Sublime Text 3

    When we’re writing queries for Drill, we can spend a lot of time jumping back and forth between a text editor and sqlline. The text editor is used to write the query, and sqlline to run the query.

  • Ansible Logs and High Resolution Times in Drill

    Ansible is a tool for automation. I use it for lots of stuff, and sometimes it would be useful to compare runs of the same playbooks, particularly runtime of things like performance tests. So I need to make ansible log what it’s doing, and then I want to be able to query the logs. Ideally, I want to do this with minimal fuss.

  • POSTing a storage plugin with an SSL-enabled drillbit

    I spent a couple hours trying to get a drill storage plugin into a drillbit with SSL enabled. I finally solved it so I thought I’d share here in case anyone else has the same need. Here’s the scenario.

View My GitHub Profile