Uploaded image for project: 'Pig'
  1. Pig
  2. PIG-3936

DBStorage fails on storing nulls for non varchar columns

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.13.0
    • Component/s: piggybank
    • Labels:
      None
    • Patch Info:
      Patch Available

      Description

      When trying to store a null value into an integer column in Postgres we were getting a JDBC error on the insert statement. I tracked it down to always using varchar as the type when writing nulls in Pig.

      To fix the issue I use the schema (if present) to determine the type of the field with the null value.

        Attachments

        1. PIG-3936.patch
          8 kB
          Jeremy Karn

          Activity

            People

            • Assignee:
              jeremykarn Jeremy Karn
              Reporter:
              jeremykarn Jeremy Karn
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: