Uploaded image for project: 'Hadoop Map/Reduce'
  1. Hadoop Map/Reduce
  2. MAPREDUCE-3876

vertica query, sql command not properly ended

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • 1.0.0
    • None
    • test
    • Red Hat 5.5
      Oracle 11

    • Apply to fresh version of 1.0.0

    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)

      Attachments

        1. HADOOP-oracleDriver-src.patch
          24 kB
          Joseph Doss

        Activity

          People

            Unassigned Unassigned
            josephdoss Joseph Doss
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: