[MAPREDUCE-3876] vertica query, sql command not properly ended

• Type: Bug
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.0.0
• Component/s: test
• Labels: BB2015-05-TBR hadoop newbie patch

Environment

Red Hat 5.5
Oracle 11

• Target Version/s: 1.0.0
• Release Note: Apply to fresh version of 1.0.0
• Assignee: Unassigned Assign to me
• Reporter: Joseph Doss
• Created: 17/Feb/12 17:09
• Updated: 06/May/15 03:31

Description

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)