Comments on Tom White: Hadoop Query Languages

Tom,Business.com has developed CloudBase- a data w...

2008-12-29T20:23:00.000Z

Tom,

Business.com has developed CloudBase- a data warehouse system on top of Hadoop that supports ANSI SQL as its query language.

CloudBase-1.1 was released last week-

http://cloudbase.sourceforge.net

CloudBase creates a database system directly on flat files and converts input ANSI SQL expressions into map-reduce programs for processing flat files. It has an optimized algorithm to handle Joins and plans to support table indexing in next release.

CloudBase comes with a JDBC driver so one can use third party BI tools, reporting frameworks to directly connect to CloudBase.

-Tarandeep

Theo, Thanks for the pointers - I'll have a look a...

2008-08-26T09:35:00.000+01:00

Theo, Thanks for the pointers - I'll have a look at them.

Jeff, Hive isn't quite in Hadoop trunk yet. The source has been released though: I've been having a play with it and I like it. (The Jira ticket is linked from the entry BTW, but here it is again: HADOOP-3601).

Tom

Yo,Hive hit trunk recently, might be worth updatin...

2008-08-26T02:25:00.000+01:00

Yo,

Hive hit trunk recently, might be worth updating with a link to the JIRA ticket?

Later,
Jeff

Tom: Have you looked at the SQL/DB research out th...

2008-06-25T01:44:00.000+01:00

Tom:

Have you looked at the SQL/DB research out there? I became aware of Berkeley's Telegraph project for federated data queries, and CWI's MonetDB project for column oriented data. Both projects also reason about nebulous data sets created by sensor networks and it just give me a new sense of the wonderful world of information processing on a global scale.

Theo