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] [Updated] (SQOOP-2272) Import decimal columns from mysql to hive 0.14
Date Mon, 20 Mar 2017 00:23:42 GMT

     [ 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.2.patch

Latest patch based on review feedback.

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

Mime
View raw message