Sqoop
  1. Sqoop
  2. SQOOP-484

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

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Affects Version/s: 1.4.1-incubating
    • Fix Version/s: 1.4.2
    • Component/s: docs
    • Labels:
      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.

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

        Activity

          People

          • Assignee:
            Jarek Jarcec Cecho
            Reporter:
            Jarek Jarcec Cecho
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development