sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Lin (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-2272) Import decimal columns from mysql to hive 0.14
Date Sun, 12 Mar 2017 09:40:04 GMT

    [ https://issues.apache.org/jira/browse/SQOOP-2272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15906470#comment-15906470

Eric Lin commented on SQOOP-2272:

I will try to see if I can add a patch to this issue.

> 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
> 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