Open Source 'Lingual' Helps SQL Devs Unlock Hadoop

Concurrent--the driving force behind Cascading, an open source Big Data application framework that gives Java developers the capability to leverage their skills to write MapReduce jobs--is gearing up a new open source project to help you use SQL skills to work with Hadoop.

Fri, February 22, 2013

CIO — One commonly cited stumbling block to the broader adoption of Apache Hadoop in the enterprise is the difficulty and expense of finding and hiring developers who understand and can think in Hadoop MapReduce. But Big Data application framework specialist Concurrent wants to change that.

Open Source 'Lingual' Helps SQL Devs Unlock Hadoop

Concurrent is already the driving force behind Cascading, a stand-alone open source Java application framework designed by Concurrent founder and CTO Chris Wensel as an alternative API to MapReduce.

Cascading gives Java developers the capability to build Big Data applications on Hadoop using their existing skillset. Now Concurrent hopes to help SQL users get into the act with Lingual, an open source ANSI-standard SQL engine that runs on top of Cascading.

Lingual Lets Analysts, Developers Tap SQL Skills for Hadoop

Lingual, which will be publicly available under the Apache 2.0 license within the next few weeks, gives analysts and developers familiar with SQL, JDBC and traditional BI tools the caoability to create and run Big Data applications on Hadoop using their existing skillsets.

"Concurrent was established with the belief that there had to be a simpler path to mass Hadoop adoption," Wensel says. "And since day one, we have worked to create solutions that make it easier for developers to build powerful and robust Big Data applications quickly and easily. With the Lingual project, we are one huge step closer to realizing our mission."

To date, many Hadoop users have turned to Apache Hive (a data warehouse infrastructure built for Hadoop) and Apache Pig (a high-level platform for creating MapReduce programs) to achieve SQL-like capabilities.

"Pig and Hive have their own qualities and actually are quite good, but sometimes you just want SQL," Wensel says. "Lingual is great for people who don't know how to use Hadoop but know SQL. The best way to get value out of something in many cases is just to use SQL."

"We just want to make it easier for people to get data off Hadoop or to port their apps to Hadoop using skills they already know," he adds.

Use Cases for Open Source Lingual SQL Parser

Example use cases for Lingual include the following:

  • Giving data analysts, scientists and developers the capability to "cut and paste" existing ANSI SQL code from traditional data warehouses and instantly access data locked on a Hadoop cluster

  • Giving developers the capability to use a standard Java JDBC interface to create new Hadoop applications or use any of the Cascading APIs and languages, like Scalding and Cascalog

  • Giving companies the capability to query and export data from Hadoop directly into traditional BI tools

Continue Reading

Our Commenting Policies