You are viewing a plain text version of this content. The canonical link for it is here.
Posted to mapreduce-issues@hadoop.apache.org by "Allen Wittenauer (JIRA)" <ji...@apache.org> on 2015/05/06 05:33:10 UTC

[jira] [Updated] (MAPREDUCE-3876) vertica query, sql command not properly ended

     [ https://issues.apache.org/jira/browse/MAPREDUCE-3876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Allen Wittenauer updated MAPREDUCE-3876:
----------------------------------------
    Labels: BB2015-05-TBR hadoop newbie patch  (was: hadoop newbie patch)

> 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: BB2015-05-TBR, 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 was sent by Atlassian JIRA
(v6.3.4#6332)