Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
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