Hadoop Map/Reduce
  1. Hadoop Map/Reduce
  2. MAPREDUCE-3876

vertica query, sql command not properly ended

    Details

    • Type: Bug Bug
    • Status: Patch Available
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: 1.0.0
    • Fix Version/s: None
    • Component/s: test
    • Labels:
    • Environment:

      Red Hat 5.5
      Oracle 11

    • Target Version/s:
    • Release Note:
      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)

        Activity

        Joseph Doss made changes -
        Attachment HADOOP-oracleDriver-src.patch [ 12516880 ]
        Joseph Doss made changes -
        Field Original Value New Value
        Status Open [ 1 ] Patch Available [ 10002 ]
        Release Note Apply to fresh version of 1.0.0
        Target Version/s 1.0.0 [ 12318240 ]
        Labels hadoop newbie patch
        Joseph Doss created issue -

          People

          • Assignee:
            Unassigned
            Reporter:
            Joseph Doss
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:

              Development