sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mehant Baid (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-2272) Import decimal columns from mysql to hive 0.14
Date Tue, 07 Feb 2017 19:49:41 GMT

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

Mehant Baid commented on SQOOP-2272:

[~pawaremail@gmail.com] Were you able to figure a workaround? I'm running into a similar 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
> 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