From the exception :
java.io.IOException: ORA-00933: SQL command not properly ended
I would broadly guess that Oracle JDBC driver might be complaining that
the statement does not end with ";", or something similar. you can
1. download the latest source code of hadoop
2. add a print statement printing the query (probably in DBInputFormat:119)
3. build hadoop jar
4. use the new hadoop jar to see the actual SQL query
5. run the query on Oracle if is gives an error.
Enis
Amandeep Khurana wrote:
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
