Uploaded image for project: 'Sqoop (READ-ONLY)'
  1. Sqoop (READ-ONLY)
  2. SQOOP-43

Boolean columns don't seem to export correctly with PostgreSQL

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.0, 1.1.0, 1.2.0
    • Fix Version/s: None
    • Component/s: export, vendors/postgres
    • Labels:
      None

      Description

      Exporting a boolean column in PostgreSQL (only tried direct mode so far) just results in a single char 't' or 'f'. Importing this into Hive seems to result only in NULL values. I'm not exactly sure but Hive seems to expect the Thrift representation of a Boolean which would probably be different from 't'/'f' so this won't work. If this is true it unfortunately means that we either have to change every output row or teach Hive to CAST (I've seen that somewhere in the Hive documentation but I'm not sure how it works yet) those values properly.

      I've only mentioned PostgreSQL but this problem might exist for other databases too? I will try to test this more next week.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              lars_francke Lars Francke
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: