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.
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.
- 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
|ANSI SQL||Going beyond ‘SQL-like’, Lingual is a mature implementation of ANSI/ISO standard SQL-99 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|
<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.1.0</version> </dependency>
To include the Lingual platform library:
<dependency> <groupId>cascading</groupId> <artifactId>lingual-platform</artifactId> <version>1.1.0</version> </dependency>
To include the Lingual local library:
<dependency> <groupId>cascading</groupId> <artifactId>lingual-local</artifactId> <version>1.1.0</version> </dependency>
To include the Lingual Hadoop library:
<dependency> <groupId>cascading</groupId> <artifactId>lingual-hadoop</artifactId> <version>1.1.0</version> </dependency>
To include the Lingual Hadoop2-mr1 library:
<dependency> <groupId>cascading</groupId> <artifactId>lingual-hadoop2-mr1</artifactId> <version>1.1.0</version> </dependency>
Lingual was created in collaboration by the developers of Cascading and Optiq, and relies on the robustness of both. Cascading is the de facto Java API for creating complex data processing workloads and the engine underneath Scalding, Cascalog, and others. Optiq is a SQL parser and optimizer written by the author of Mondrian.
curl http://files.cascading.org/lingual/1.1/lingual-client/install-lingual-client.sh | bash
|Cascading Lingual – ANSI SQL for Hadoop (19 min)|
|Introduction to Cascading – Lingual (5 min)|
|Accessing HBase with Cascading Lingual|
|Accessing Oracle with Cascading Lingual|
|Accessing Redshift with Cascading Lingual|