|| at Jul 28, 2009 at 7:30 am
On Mon, Jul 27, 2009 at 9:24 PM, po po wrote:
Hello,I try to use DBInputFormat with database sql server 2000 and got
"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.