Ok. I created the same database in a MySQL database and ran the same hadoop job against it. It worked. So, that means there is some Oracle specific issue. It cant be an issue with the JDBC drivers since I am using the same drivers in a simple JDBC client.
What could it be? Amandeep Amandeep Khurana Computer Science Graduate Student University of California, Santa Cruz On Wed, Feb 4, 2009 at 10:26 AM, Amandeep Khurana <ama...@gmail.com> wrote: > Ok. I'm not sure if I got it correct. Are you saying, I should test the > statement that hadoop creates directly with the database? > > Amandeep > > > Amandeep Khurana > Computer Science Graduate Student > University of California, Santa Cruz > > > On Wed, Feb 4, 2009 at 7:13 AM, Enis Soztutar <enis....@gmail.com> wrote: > >> Hadoop-2536 connects to the db via JDBC, so in theory it should work with >> proper jdbc drivers. >> It has been tested against MySQL, Hsqldb, and PostreSQL, but not Oracle. >> >> To answer your earlier question, the actual SQL statements might not be >> recognized by Oracle, so I suggest the best way to test this is to insert >> print statements, and run the actual SQL statements against Oracle to see if >> the syntax is accepted. >> >> We would appreciate if you publish your results. >> >> Enis >> >> >> Amandeep Khurana wrote: >> >>> Does the patch HADOOP-2536 support connecting to Oracle databases as >>> well? >>> Or is it just limited to MySQL? >>> >>> Amandeep >>> >>> >>> Amandeep Khurana >>> Computer Science Graduate Student >>> University of California, Santa Cruz >>> >>> >>> >> >
