Hi Guys ,
I am facing the Error while extracting the data from Mysql Table BigInt Column using tMysqlInput Component.
The Column datatype is : course_id` bigint(30) unsigned NOT NULL
It has the records with 11-digit Number, Eg : 30001000008. If I try to return only 10-digits from this number, then its returning without any error. But when I tried to return the total number (in my case 11-digit) it returns the following Error as show below.
Exception in component tMysqlInput_2
com.mysql.jdbc.exceptions.jdbc4.MySQLDataException: '1.0001000001E10' in column '1' is outside valid range for the datatype INTEGER.
Is it requires any Extra-Settings in Additional JDBC Parameters Option to work around on this.
I am using Talend Open Studio 5.5.0 Version, CentOS.
Thanks In Advance,
Solved! Go to Solution.
Thanks vapukov for your Solution. I have changed the same in my design. Its working fine.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Create systems and workflow to manage clean data ingestion and data transformation.