[
https://issues.apache.org/jira/browse/SQOOP-2272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15932937#comment-15932937
]
Attila Szabo commented on SQOOP-2272:
-------------------------------------
Hey [~ericlin],
I've reviewed your changeset, and left some comments + questions.
Please have a look when you have time!
[~abrahamfine], [~szonyi], [~markuskem...@me.com],
Would you please check my review+comments, and tell if you also share my
concerns around changing the default behaviour? (maybe I'm just too paranoid
from the end user POV, and we could just safely depend on explicit type
mappings)
Many thanks in advance!
Cheers,
[~maugli]
> 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)
