sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "sravan kumar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-3189) Issue while reading double(data type) data from Sql server DB and loading in to Hive String (data type) with Sqoop
Date Fri, 12 May 2017 15:43:04 GMT

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

sravan kumar commented on SQOOP-3189:
-------------------------------------

I am having some data type conversion issue in Sqoop while loading data in to hive.

Example:

Source is Sql server Data base, column data type in source is float,Value from source: 36408272

My hive table columns must be string and i am loading data using Sqoop reading from sql server
data base.Issue is while loading float/double coulms in to string i see the value is loaded
as : 3.6408272E7.

Is there any way that we can read float/double columns as string before landing the data in
to hive? Like wise i need the data to be corrected before we land on HDFS

> Issue while reading double(data type) data from Sql server DB and loading in to Hive
String (data type) with Sqoop
> ------------------------------------------------------------------------------------------------------------------
>
>                 Key: SQOOP-3189
>                 URL: https://issues.apache.org/jira/browse/SQOOP-3189
>             Project: Sqoop
>          Issue Type: Bug
>          Components: sqoop2-client
>            Reporter: sravan kumar
>




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message