Ok, I will try it.Thanks On Tue, Jul 28, 2009 at 1:29 PM, Amandeep Khurana <[email protected]> wrote:
> 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 > > >
