Feeds

Concurrent gives old SQL users new Hadoop tricks

Lingual lets SQL devs speak HDFS lingo

Providing a secure and efficient Helpdesk

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. ®

Security for virtualized datacentres

Whitepapers

Providing a secure and efficient Helpdesk
A single remote control platform for user support is be key to providing an efficient helpdesk. Retain full control over the way in which screen and keystroke data is transmitted.
WIN a very cool portable ZX Spectrum
Win a one-off portable Spectrum built by legendary hardware hacker Ben Heck
Saudi Petroleum chooses Tegile storage solution
A storage solution that addresses company growth and performance for business-critical applications of caseware archive and search along with other key operational systems.
Protecting users from Firesheep and other Sidejacking attacks with SSL
Discussing the vulnerabilities inherent in Wi-Fi networks, and how using TLS/SSL for your entire site will assure security.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.