Pawan Pawar created SQOOP-2272:
----------------------------------
Summary: 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
Priority: Minor
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.4#6332)
