Details
-
Bug
-
Status: Patch Available
-
Major
-
Resolution: Unresolved
-
1.4.5
-
None
-
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
Attachments
Issue Links
- is duplicated by
-
SQOOP-3059 sqoop import into hive converting decimals to decimals
- Open
- links to