Pluggable JDBC schemas [Was: How to use DBInputFormat?]

2009-02-13 Thread Fredrik Hedberg
Hi, Please let us know how this works out. Also, it would be nice if people with experience with other RDMBS than MySQL and Oracle could comment on the syntax and performance of their respective RDBMS with regard to Hadoop. Even if the syntax of the current SQL queries are valid for

Re: Pluggable JDBC schemas [Was: How to use DBInputFormat?]

2009-02-13 Thread Edward Capriolo
One thing to mention is 'limit' is not SQL standard. Microsoft SQL Server uses the SELECT TOP 100 FROM table. Some RDBMS may not support any such syntax. To be more SQL compliant you should use some data like an auto ID or DATE column for an offset. It is tricky to write anything truly database