Uploaded image for project: 'Sqoop (Retired)'
  1. Sqoop (Retired)
  2. SQOOP-484

Update troubleshooting guide section about MySQL and TINYINT(1) columns

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Trivial
    • Resolution: Fixed
    • 1.4.1-incubating
    • 1.4.2
    • docs
    • None

    Description

      This issue is continuation of JIRA ticket SQOOP-463.

      I've investigated MySQL JDBC connector behavior in case of columns defined as TINYINT(1). By default MySQL JDBC connector is converting TINYINT(1) into java.sql.Types.BIT, which can be very easily turned off by specifying tinyInt1isBit=false in JDBC path. For example jdbc:mysql://localhost/test?tinyInt1isBit=false. I would suggest to update troubleshooting guide by suggesting users to set this property rather than overriding default sqoop type mapping.

      Attachments

        1. SQOOP-484.patch
          2 kB
          Jarek Jarcec Cecho
        2. SQOOP-484.patch
          2 kB
          Jarek Jarcec Cecho

        Activity

          People

            jarcec Jarek Jarcec Cecho
            jarcec Jarek Jarcec Cecho
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: