Senthil Ganesh created SQOOP-3063:
-------------------------------------
Summary: CDH 5U8- TDCH FLOAT value 2.26e-308 is not working
Key: SQOOP-3063
URL: https://issues.apache.org/jira/browse/SQOOP-3063
Project: Sqoop
Issue Type: Bug
Reporter: Senthil Ganesh
sqoop import --password ****** --map-column-java
col1_byteint=Integer,col2_smallint=Integer,col3_integer=Integer,col6_float=Double,col9_char=String,col10_varchar=String,col11_char_cs=String,col12_varchar_cs=String,col16_bigint=Long,col_key=Integer
--connect jdbc:teradata://10.65.43.30/database=dwtera,charset=UTF8 --username
dwtera --driver com.teradata.jdbc.TeraDriver --as-avrodatafile --split-by
col_key --where
0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000226
= TD_all_dtype_sqoop_src.col6_float --columns
col1_byteint,col2_smallint,col3_integer,col4_decimal,col5_dec_no_length,col6_float,col9_char,col10_varchar,col11_char_cs,col12_varchar_cs,col13_date,col14_time,col15_timestamp,col16_bigint,col_key
--compress --table TD_all_dtype_sqoop_src --target-dir
hdfs://ivlhdp258.informatica.com:8020/blaze/workdir/29619794428028430/W29619794428028430_Read_TD_all_dtype_sqoop_src_sqoop_m_07_all_dtyp_td_flter_td_no_byte_varbyte1/staged_files
016-09-17 11:11:17 <TASK_140255514511104-MAPPING> INFO: [APPSDK_Msg_1762]
SQOOP_HOME is unset. May not be able to find all job dependencies.
2016-09-17 11:11:17 <TASK_140255514511104-MAPPING> INFO: [APPSDK_Msg_1762]
Connecting to ResourceManager at ivlhdp258.informatica.com/10.65.147.72:8032
2016-09-17 11:11:20 <TASK_140255514511104-MAPPING> INFO: [APPSDK_Msg_1762]
Using read commited transaction isolation
2016-09-17 11:11:20 <TASK_140255514511104-MAPPING> INFO: [APPSDK_Msg_1762]
BoundingValsQuery: SELECT MIN(col_key), MAX(col_key) FROM
TD_all_dtype_sqoop_src WHERE (
0.0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000226
= TD_all_dtype_sqoop_src.col6_float )
2016-09-17 11:11:20 <TASK_140255514511104-MAPPING> INFO: [APPSDK_Msg_1762]
Cleaning up the staging area
/tmp/hadoop-yarn/staging/qamercury/.staging/job_1473759670660_0183
2016-09-17 11:11:20 <TASK_140255514511104-MAPPING> INFO: [APPSDK_Msg_1762]
PriviledgedActionException as:qamercury (auth:PROXY) via yarn (auth:SIMPLE)
cause:java.io.IOException: java.sql.SQLException: [Teradata Database] [TeraJDBC
15.10.00.09] [Error 3753] [SQLState 22003] Too many digits in integer or
decimal constant.
2016-09-17 11:11:20 <TASK_140255514511104-MAPPING> INFO: [APPSDK_Msg_1762]
Encountered IOException running import job: java.io.IOException:
java.sql.SQLException: [Teradata Database] [TeraJDBC 15.10.00.09] [Error 3753]
[SQLState 22003] Too many digits in integer or decimal constant.
2016-09-17 11:11:20 <TASK_140255514511104-MAPPING> INFO: [APPSDK_Msg_1762]
at
org.apache.sqoop.mapreduce.db.DataDrivenDBInputFormat.getSplits(DataDrivenDBInputFormat.java:203)
2016-09-17 11:11:20 <TASK_140255514511104-MAPPING> INFO: [APPSDK_Msg_1762]
at
org.apache.hadoop.mapreduce.JobSubmitter.writeNewSplits(JobSubmitter.java:305)
2016-09-17 11:11:20 <TASK_140255514511104-MAPPING> INFO: [APPSDK_Msg_1762]
at org.apache.hadoop.mapreduce.JobSubmitter.writeSplits(JobSubmitter.java:322)
2016-09-17 11:11:20 <TASK_140255514511104-MAPPING> INFO: [APPSDK_Msg_1762]
at
org.apache.hadoop.mapreduce.JobSubmitter.submitJobInternal(JobSubmitter.java:200)
2016-09-17 11:11:20 <TASK_140255514511104-MAPPING> INFO: [APPSDK_Msg_1762]
at org.apache.hadoop.mapreduce.Job$10.run(Job.java:1307)
Thanks & Regards,
Rohith
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
