Lingual

ANSI SQL on Cascading (on whatever platform you choose).

We have limited time to maintain this project, please contact us if interested in helping.

Lingual was created for developers who want to…

Quickly build applications using existing or new SQL queries
Install nothing, all dependencies are through Maven

About Lingual

Migrate Workloads to Apache Hadoop or Apache Tez

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.

Simplify Systems Integration

Lingual inherits the power of Cascading, which means you can now integrate and process data from heterogeneous sources with one SQL statement over JDBC.

Lingual Provides

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

Catalog

Command line tool that allows users to curate a catalog of database tables mapping to Hadoop files and resources

Data Provider

Allows Lingual to query data simultaneously from multiple external systems with a single SQL statement

Quick Install

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

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.