Feeds

Concurrent gives old SQL users new Hadoop tricks

Lingual lets SQL devs speak HDFS lingo

Build a business case: developing custom apps

Application framework specialist Concurrent has given SQL devs a free tool to get at data stored in Hadoop, without having to learn the intricacies of the trendy computational framework.

The "Lingual" tool is an ANSI-standard SQL engine built on top of Concurrent's "Cascading" software, a Java application framework for Hadoop.

"All we've done is glue an SQL parser on top [of Cascading] to allow people to complete Hadoop applications," Concurrent CTO Chris Wensel told The Register.

To get data in and out of Hadoop you need to have some level of familiarity with theHadoop distributed filesystem (HDFS), Wensel explained.

Developers that deal with the system regularly are rare as hen's teeth compared to the vast army of analysts, marketers, and IT workers that can bash out an SQL query.

The Lingual tool lets these SQL workers speak HDFS's language without having to learn it.

For example, many financial analysts want to get data out of Hadoop and play with it in R, a statistics program. Lingual lets them do that, he said.

The tool could also save companies money, as it provides a relatively quick way for experts to migrate data off of large Greenplum or Teradata clusters.

"eBay has this problem," Wensel says. "Their Teradata users have a Hadoop cluster and are paying an arm and a leg, and are probably overprovisioning it."

Lingual is available beginning on Wednesday. If you are not a Cascading user, you will need to download both free software packages. ®

Boost IT visibility and business value

More from The Register

next story
Sysadmin Day 2014: Quick, there's still time to get the beers in
He walked over the broken glass, killed the thugs... and er... reconnected the cables*
Auntie remains MYSTIFIED by that weekend BBC iPlayer and website outage
Still doing 'forensics' on the caching layer – Beeb digi wonk
SHOCK and AWS: The fall of Amazon's deflationary cloud
Just as Jeff Bezos did to books and CDs, Amazon's rivals are now doing to it
VVOL update: Are any vendors NOT leaping into bed with VMware?
It's not yet been released but everyone thinks it's the dog's danglies
BlackBerry: Toss the server, mate... BES is in the CLOUD now
BlackBerry Enterprise Services takes aim at SMEs - but there's a catch
prev story

Whitepapers

Implementing global e-invoicing with guaranteed legal certainty
Explaining the role local tax compliance plays in successful supply chain management and e-business and how leading global brands are addressing this.
The Essential Guide to IT Transformation
ServiceNow discusses three IT transformations that can help CIO's automate IT services to transform IT and the enterprise.
Consolidation: The Foundation for IT Business Transformation
In this whitepaper learn how effective consolidation of IT and business resources can enable multiple, meaningful business benefits.
How modern custom applications can spur business growth
Learn how to create, deploy and manage custom applications without consuming or expanding the need for scarce, expensive IT resources.
Build a business case: developing custom apps
Learn how to maximize the value of custom applications by accelerating and simplifying their development.