[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

2017-07-06 Thread Eric Lin (JIRA) 

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

Eric Lin commented on SQOOP-3189:
-

Hi [~sravan777],

Can you please clarify whether this is Sqoop1 or Sqoop2 issue? Can you please 
also provide the full command you used to run Sqoop?

This will help us to understand the issue better.

Thanks

> 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.4.14#64029)

[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

2017-05-12 Thread sravan kumar (JIRA) 

[ 
https://issues.apache.org/jira/browse/SQOOP-3189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=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)