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

postgresql bulk loader doesn't work (Delimiter and Enclosure is swaped)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: 3.1.0 GA
    • Fix Version/s: 3.2.3, 4.0.0 GA
    • Component/s: Spoon / User Interface
    • Labels:
      None
    • Environment:
      build 3.1.0 RC1 build 811
    • 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.
    • Operating System/s:
      Windows XP

      Description

      When using the postgresql bulk loader the target table isn't filled with data.
      The load0.dat file is correctly created. (although the directory assignment in the step properties don't work)
      The log file is not created although I made the settings in the step properties.
      The control0.cfg file is also created. The parameters in it are good, but I don't know if they are complete:
      \COPY "public".aanslagbiljet ( abt_heffingsjaar, abt_relat_sbj, abt_dagtekening, abt_vervaldatum, abt_id, abt_identificatie ) FROM /tmp/load0.dat WITH CSV DELIMITER AS ';' QUOTE AS '"'

      When I use psql stand-alone, I use the following parameters: (and this works)
      "C:\Program Files\PostgreSQL\8.1\bin\psql.exe" -h 192.168.1.201 -p 5432 -U postgres -d belmag4-0 -c "COPY aanslagbiljet ( abt_heffingsjaar, abt_relat_sbj, abt_dagtekening, abt_vervaldatum, abt_id, abt_identificatie ) FROM STDIN WITH CSV DELIMITER AS ';' QUOTE AS '\"' < f:\tmp\load0.dat

      Note the escape character at defining the quote character and the file parameter in the control0.log hasn't a drive letter in it's path.
      The database server is another machine the the server executing and 'holding' the pdi programs and transformation en job files.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                gdavid Golda Thomas
                Reporter:
                rutgerdow Rutger Deterd Oude Weme
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: