[
https://issues.apache.org/jira/browse/MAPREDUCE-3876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Joseph Doss updated MAPREDUCE-3876:
-----------------------------------
Attachment: HADOOP-oracleDriver-src.patch
Only tested on a fresh version of 1.0.0
> vertica query, sql command not properly ended
> ---------------------------------------------
>
> Key: MAPREDUCE-3876
> URL: https://issues.apache.org/jira/browse/MAPREDUCE-3876
> Project: Hadoop Map/Reduce
> Issue Type: Bug
> Components: test
> Affects Versions: 1.0.0
> Environment: Red Hat 5.5
> Oracle 11
> Reporter: Joseph Doss
> Labels: hadoop, newbie, patch
> Attachments: HADOOP-oracleDriver-src.patch
>
>
> When running a test script, we're getting a java IO exception thrown.
> This test works on hadoop-0.20.0 but not on hadoop-1.0.0.
> Fri Feb 17 11:36:40 EST 2012
> Running processes with name syncGL.sh: 0
> LIB_JARS:
> /home/hadoop/verticasync/lib/vertica_4.1.14_jdk_5.jar,/home/hadoop/verticasync/lib/mail.jar,/home/hadoop/verticasync/lib/jdbc14.jar
> VERTICA_SYNC_JAR: /home/hadoop/verticasync/lib/vertica-sync.jar
> PROPERTIES_FILE:
> /home/hadoop/verticasync/config/ssp-vertica-sync-gl.properties
> Starting Vertica data sync - GL - process
> Warning: $HADOOP_HOME is deprecated.
> 12/02/17 11:36:43 INFO mapred.JobClient: Running job: job_201202171122_0001
> 12/02/17 11:36:44 INFO mapred.JobClient: map 0% reduce 0%
> 12/02/17 11:36:56 INFO mapred.JobClient: Task Id :
> attempt_201202171122_0001_m_000000_0, Status : FAILED
> java.io.IOException: ORA-00933: SQL command not properly ended
> at
> org.apache.hadoop.mapred.lib.db.DBInputFormat.getRecordReader(DBInputFormat.java:289)
> at
> org.apache.hadoop.mapred.MapTask$TrackedRecordReader.<init>(MapTask.java:197)
> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:418)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:372)
> at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:396)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1083)
> at org.apache.hadoop.mapred.Child.main(Child.java:249)
> 12/02/17 11:36:57 INFO mapred.JobClient: Task Id :
> attempt_201202171122_0001_m_000001_0, Status : FAILED
> java.io.IOException: ORA-00933: SQL command not properly ended
> at
> org.apache.hadoop.mapred.lib.db.DBInputFormat.getRecordReader(DBInputFormat.java:289)
> at
> org.apache.hadoop.mapred.MapTask$TrackedRecordReader.<init>(MapTask.java:197)
> at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:418)
> at org.apache.hadoop.mapred.MapTask.run(MapTask.java:372)
> at org.apache.hadoop.mapred.Child$4.run(Child.java:255)
> at java.security.AccessController.doPrivileged(Native Method)
> at javax.security.auth.Subject.doAs(Subject.java:396)
> at
> org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1083)
> at org.apache.hadoop.mapred.Child.main(Child.java:249)
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
