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

Import decimal columns from mysql to hive 0.14

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • 1.4.5
    • None
    • sqoop2-shell
    • None

    Description

      I am importing data from mysql to hive. several columns in source table are of type decimal. but sqoop convert this types into the double. How can I import that table with same precision and scale in hive.

      My query is:

      sqoop import --connect jdbc:mysql://localhost:3306/SourceDataBase?zeroDateTimeBehavior=convertToNull --username root --password root --hive-table MyHiveDatabaseName.MyTableName --hive-import --hive-table MyHiveDatabaseName.MyTableName --query 'select * from MyTableName where $CONDITIONS' -m 1 --target-dir /user/hive/warehouse/MyHiveDatabaseName/MyTableName

      Attachments

        1. SQOOP-2272.5.patch
          13 kB
          Eric Lin
        2. SQOOP-2272.4.patch
          13 kB
          Eric Lin
        3. SQOOP-2272.3.patch
          13 kB
          Eric Lin
        4. SQOOP-2272.2.patch
          10 kB
          Eric Lin
        5. SQOOP-2272.patch
          9 kB
          Eric Lin

        Issue Links

          Activity

            People

              ericlin Eric Lin
              pawaremail@gmail.com Pawan Pawar
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated: