Sqoop
  1. Sqoop
  2. SQOOP-463

Sqoop User Guide's troubleshooting section should explain how to override the column mapping when importing a table from MySQL into Hive

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.4.1-incubating
    • Fix Version/s: 1.4.2
    • Component/s: docs
    • Labels:
      None

      Description

      When importing a table from MySQL into Hive where one of the columns is of datatype TINYINT(1), Sqoop will automatically map this to the Hive datatype boolean. This is because the MySQL JDBC connector maps the TINYINT(1) datatype to java.sql.Types.BIT, which Sqoop by default maps to the Hive type Boolean. Consequently, if you have values such as 1 or 0 in this column, they will fail to parse correctly in Hive, instead appearing as all NULL values.

      1. SQOOP-463-2.patch
        1 kB
        Kathleen Ting
      2. SQOOP-463-1.patch
        1 kB
        Kathleen Ting
      3. SQOOP-463.patch
        1 kB
        Kathleen Ting

        Activity

        No work has yet been logged on this issue.

          People

          • Assignee:
            Kathleen Ting
            Reporter:
            Kathleen Ting
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development