17 December 2013 25 Comments

Connecting Tableau to ElasticSearch (READ: How to query ElasticSearch with Hive SQL and Hadoop)

I’ve been a big fan of ElasticSearch the since last Spring. Put simply, it’s a search server based on Apache Lucene. But in all honestly, it’s really a massively scalable, auto-balancing, redundant, NoSQL data-store plus a full search and analytics server.

But, if I’m storing a ton of data in ES, I certainly can’t use Tableau, since ES querying is strictly RESTful… or can I?

29 August 2013 0 Comments

RiffBank – Parsing arbitrary Text-based Guitar Tab into an Indexable and Queryable “RiffCode for ElasticSearch

Guitar tablature is meant for human readability…not for machine consumption. Granted it’s “procedural” and “linear” already, but it’s also column-based AND row-based at the same time (readers read down a short row and then over) – you are dealing with text chunks that are easily understandable by a human, but require a lot of “context” […]

21 August 2013 1 Comment

RiffBank – Indexing “Guitar Tab Data” as a pseudo-language with ElasticSearch

What is it? A fun data/hack project that I’ve been working on for the past few weeks. Basically put… Riffbank is a “reverse search engine” for guitar tabs. Give it a simple section of guitar tab (a “riff”), and it will tell you what songs it could be (plus any other metadata it knows). Give […]