sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Attila Szabo (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-2272) Import decimal columns from mysql to hive 0.14
Date Mon, 20 Mar 2017 16:11:41 GMT

    [ 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], [~markuskemper@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!


> 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

View raw message