Uploaded image for project: 'Pentaho Data Integration - Kettle'
  1. Pentaho Data Integration - Kettle
  2. PDI-11094

Vertica Bulk Loader Always Fails Saying Column Type not Supported (Vertica 7)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Cannot Reproduce
    • Affects Version/s: 5.0.1 GA
    • Fix Version/s: 5.1.0 GA
    • Component/s: Step
    • Labels:
    • Environment:
      Vertica 7.0.0 Community Edition
      PDI 5.0.1
    • Story Points:
      5
    • PDI Sub-component:
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Pervach

      Description

      The Vertica bulk loader always fails with a Column type not supported error message. I have tested columns with types int,smallint, bigint, binary, char, varchar, long varchar and they all failed with a similar message. Writing the data to a file and then using a Vertica copy command to bulk load works for the same column types.

      2013/12/13 10:55:05 - Vertica Bulk Loader.0 - ERROR (version 5.0.1, build 1 from 2013-10-30_19-53-32 by buildguy) : Unexpected error
      2013/12/13 10:55:05 - Vertica Bulk Loader.0 - ERROR (version 5.0.1, build 1 from 2013-10-30_19-53-32 by buildguy) : java.lang.IllegalArgumentException: Column type Varchar not supported.
      2013/12/13 10:55:05 - Vertica Bulk Loader.0 - at org.pentaho.di.verticabulkload.VerticaBulkLoader.getColumnSpecFromField(VerticaBulkLoader.java:230)
      2013/12/13 10:55:05 - Vertica Bulk Loader.0 - at org.pentaho.di.verticabulkload.VerticaBulkLoader.processRow(VerticaBulkLoader.java:132)
      2013/12/13 10:55:05 - Vertica Bulk Loader.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
      2013/12/13 10:55:05 - Vertica Bulk Loader.0 - at java.lang.Thread.run(Thread.java:724)

        Attachments

          Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. PDI-11475 java.lang.IllegalArgumentException: Column type Integer not supported

          • High - An issue that impacts and reduces ability to use Pentaho in a production environment. Business operations are able to continue, however they may be highly impacted and a viable documented workaround is not available.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. PDI-9912 Pentaho Vertica Bulk Load Error IllegalArgumentException

          • High - An issue that impacts and reduces ability to use Pentaho in a production environment. Business operations are able to continue, however they may be highly impacted and a viable documented workaround is not available.
          • Closed

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              cdeptula Chris Deptula
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: