[
https://issues.apache.org/jira/browse/SQOOP-2272?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Eric Lin updated SQOOP-2272:
----------------------------
Attachment: SQOOP-2272.3.patch
> 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
> Assignee: Eric Lin
> Attachments: SQOOP-2272.2.patch, SQOOP-2272.3.patch, SQOOP-2272.patch
>
>
> 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.15#6346)
