[jira] [Created] (SQOOP-2272) Import decimal columns from mysql to hive 0.14

["Pawan Pawar (JIRA)" <ji...@apache.org>]

Pawan Pawar created SQOOP-2272:
----------------------------------

             Summary: Import decimal columns from mysql to hive 0.14
                 Key: SQOOP-2272
                 URL: https://issues.apache.org/jira/browse/SQOOP-2272
             Project: Sqoop
          Issue Type: Bug
          Components: sqoop2-shell
    Affects Versions: 1.4.5
            Reporter: Pawan Pawar
            Priority: Minor


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 




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)