On top of Hadoop 支援 ANSI SQL 的系統, 有興趣的人可以研究看看, 這個應該可是可直接 support 線上 query 的. -- Yi-Kai Tsai (cuma) <yikai@xxxxxxxxxxxxx>, Asia Regional Search Engineering.
--- Begin Message ---
- From: Tarandeep Singh <tarandeep@xxxxxxxxx>
- To: "core-user@xxxxxxxxxxxxxxxxx" <core-user@xxxxxxxxxxxxxxxxx>
- Date: Tue, 23 Dec 2008 08:14:44 +0900
Hi, We have released 1.1 version of CloudBase on sourceforge- http://cloudbase.sourceforge.net/ [ CloudBase is a data warehouse system built on top of Hadoop's Map-Reduce architecture. It uses ANSI SQL as its query language and comes with a JDBC driver. It is developed by Business.com and is released to open source community under GNU GPL license] Please give it a try and send us your feedback on CloudBase users group- http://groups.google.com/group/cloudbase-users Thanks, Tarandeep Release notes- ----------------------------------------------------------- Following new features have been added in this release- * Optimized Join algorithm * Full support for SQL NULLs * IS NULL and IS NOT NULL statements * NVL and ISNULL functions * Regression test suite * BETWEEN statement * CASE statement * CASE conditional statement * INSERT statement to load data into existent CloudBase table from local files * CONVERT function to convert expression of one data type to another * Clause added to DROP Statement to not delete data on table drop * DATETIMEADD and DATETIMEDIFF functions * Amazon AMI for CloudBase Following bugs have been fixed in this release- * Make table names and column names CASE INSENSITIVE * Top N clause was not working * SELECT * FROM table does not return columns in order * Date addition/subtraction was not working * SELECT t1.* FROM t1 INNER JOIN t2 ... returns all columns of t1 and t2 * ORDER BY clause fails if column has NULL values * SELECT * INTO new_table FROM old_table- the new_table is not created in cloudbase/data directory * INSERT * INTO new_table ( SELECT * FROM old_table) fails when new_table's column sep is TAB ('\t) * SELECT * INTO new_table ( query ) - does not check if new_table already exists * SELECT c1, COUNT(*), SUM( DISTINCT c2) FROM table1 GROUP BY c1- throws NPE * VIEWS are not shown SQUIRREL * VIEW's SQL is not shown in Squirrel * CloudBase keywords, string functions and datetime functions are not showin in Squirrel * SELECT col FROM tablename- returns NULL if col's data type is DOUBLE * Time part of the DateTime data type is not showin in Squirrel -----------------------------------------------------------
--- End Message ---