[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

["sravan kumar (JIRA)" <ji...@apache.org>]

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