topic sqoop import issue in Talend Studio

sqoop import issue

Anonymous — Sat, 16 Nov 2024 10:47:16 GMT

Hi,
When I try to import a table from mysql using Talend, I got the following error. Can you please tell me how to fix this issue.
Error: java.lang.RuntimeException: java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167)
at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtil

Re: sqoop import issue

Anonymous — Tue, 23 Feb 2016 06:56:02 GMT

Hi,
Can you upload again the screenshots you wanted to show, please? For some reason it didn't make it to your post.
Do you want to extract a table from mysql to hive using talend(big data studio)....? Usually, we use sqoop to import mysql table into hdfs firstly then using tHiveLoad to write data into hive table.
Best regards
Sabrina

Re: sqoop import issue

Anonymous — Mon, 13 Jun 2016 06:56:43 GMT

Hi All,
Can any1 solve my query.
i want to read 80 million record from mysql and write into mysql.
But after 20 million reads it gave me could not create connection error.
.
.
2016-06-10 03:07:25;aAtDjY;kC202j;kC202j;BIOWISE_ETL_JOB;BW_Dbnsfp_SNP_Job_0;Default;6;Java Exception;tMysqlInput_1;com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException:Could not create connection to database server. Attempted reconnect 3 times. Giving up.;1
can any1 ll provide solution for this?
Regards,
Anand Yadav