Lingual

Cascading Lingual is a powerful extension to Cascading that simplifies application development and integration by providing an ANSI SQL interface for Apache Hadoop. Now you can connect existing business intelligence (BI) tools, optimize computing costs, and accelerate application development with Hadoop.

Migrate Workloads to Hadoop
Optimize computing costs by quickly migrating workloads on to Hadoop through Cascading applications or simply ‘cutting and pasting’ existing data warehousing or legacy SQL statements on to Hadoop.
Export Data off Hadoop
Because Lingual is ANSI-standard compliant and supports the standard JDBC interface, you can now query and export data from Hadoop directly into traditional BI tools and other critical applications.

Lingual Benefits

Connect existing BI tools and critical applications to Hadoop
Optimize computing costs by migrating SQL queries to Hadoop
Accelerate application development and testing
Lower the Hadoop adoption barrier

KEY FEATURES

ANSI SQL
Going beyond ‘SQL-like’, Lingual is a mature implementation of ANSI/ISO standard SQL-92 built on top of the Cascading framework
JDBC Driver
The standards compliant JDBC driver enables integration with many existing BI tools and application servers
SQL Shell
An interactive SQL command interface for interacting with on Hadoop and executing SQL commands

Quick Install

curl http://files.cascading.org/lingual/1.2/lingual-client/install-lingual-client.sh | bash

USING MAVEN

Lingual is currently under active development and available as source in the Lingual project or Maven artifacts on Conjars.

To add the Conjars repository:

<repository>
  <id>conjars.org</id>
  <url>http://conjars.org/repo</url>
</repository>

To include the Lingual core library:

<dependency>
  <groupId>cascading</groupId>
  <artifactId>lingual-core</artifactId>
  <version>1.2.0</version>
</dependency>

To include the Lingual platform library:

<dependency>
  <groupId>cascading</groupId>
  <artifactId>lingual-platform</artifactId>
  <version>1.2.0</version>
</dependency>

To include the Lingual Hadoop library:

<dependency>
  <groupId>cascading</groupId>
  <artifactId>lingual-hadoop</artifactId>
  <version>1.2.0</version>
</dependency>

To include the Lingual local library:

<dependency>
  <groupId>cascading</groupId>
  <artifactId>lingual-local</artifactId>
  <version>1.2.0</version>
</dependency>

Compatibility

Cascading

Lingual integrates Cascading with the SQL query language and a JDBC driver. Because Lingual is built on top of Cascading, any Lingual based code will function with your other Cascading applications and flows.

Driven

Lingual applications will work with Driven. You can build your applications with Lingual and visualize them in Driven, just like any other Cascading application.