On Mon, Jul 27, 2009 at 9:24 PM, po po <[email protected]> wrote: > Hello,I try to use DBInputFormat with database sql server 2000 and got > error > "incorrect syntax near LIMIT". > Does hadoop support sql server 2000 ? >
DBInputFormat splits up the table to be read into chunks and each mapper gets to read a chunk. The splitting into chunks has different syntax in different databases. What you get by default supports MySQL. It didnt support Oracle and I tweaked it a little bit for that. I'm not sure if the same query will work for SQL Server but you can try it out. The patch is available on the HADOOP-5616 jira. Else, you can tweak the createQuery(..) routine in DBInputFormat to work with your DB. > > Thanks >
