topic Re: Not able load data from postgresql to hdfs using tSqoopImport in Talend Studio

Not able load data from postgresql to hdfs using tSqoopImport

Vishu1 — Sat, 16 Nov 2024 08:32:12 GMT

Hi,

I have TOS for Bigdata v6.5.1 and virtual box for cloudera CDH 5.12.

I am trying to load table 'employees' data from postgresql to HDFS using tSqoopImport component.

But getting following error:

Error employees : Unsupported major.minor version 52.0

I have checked that it is because of java version mismatch.

TOS 6.5.1 supports CDH 5.12 that is why I install Cloudera quickstart VM of v5.12 but it works on java 7 while talend requires java 8.

How can I resolve this?

Re: Not able load data from postgresql to hdfs using tSqoopImport

Vishu1 — Tue, 20 Mar 2018 08:11:38 GMT

Your help will be appriciated!

Re: Not able load data from postgresql to hdfs using tSqoopImport

Vishu1 — Wed, 21 Mar 2018 06:49:38 GMT

@rhall , @xdshi would you guys have any solutions on this.

Re: Not able load data from postgresql to hdfs using tSqoopImport

Anonymous — Wed, 21 Mar 2018 07:20:40 GMT

Hello,

You can set studio JDK compiler compliance Level as 1.7 (with restrictions).

For more restriction, please see the "Note" in this document:TalendHelpCenter:Compatible Java Environment.

Best regards

Sabrina

Re: Not able load data from postgresql to hdfs using tSqoopImport

Vishu1 — Wed, 21 Mar 2018 07:23:16 GMT

I tried this as well by setting compliance level to java 1.7 but still getting the same error.

Re: Not able load data from postgresql to hdfs using tSqoopImport

Anonymous — Wed, 21 Mar 2018 09:52:00 GMT

Hello,

Have you tried to restart your studio to see if it works?

Best regards

Sabrina

Re: Not able load data from postgresql to hdfs using tSqoopImport

Vishu1 — Wed, 21 Mar 2018 09:56:57 GMT

Yes I did that also. but still got the same error.

Re: Not able load data from postgresql to hdfs using tSqoopImport

Anonymous — Thu, 22 Mar 2018 03:48:20 GMT

Hello,

Here exists a related jira issue:https://jira.talendforge.org/browse/TBD-3673.

Could you please check the solution provided to see if it is OK with you.

Best regards

Sabrina

Re: Not able load data from postgresql to hdfs using tSqoopImport

Vishu1 — Thu, 22 Mar 2018 05:39:48 GMT

@xdshi Thanks for you time.

I am able to solve this issue.

Actually, My cloudera VM is running on 'java 7 update 67' and I was using 'java 7 update 65' in Talend.

I replace it with and java 7 update 67 and followed by changing compliance level to 1.7, Installed JRE to 1.7, and Java interpreter to 1.7.

And it works for me.

Re: Not able load data from postgresql to hdfs using tSqoopImport

Anonymous — Thu, 22 Mar 2018 07:10:10 GMT

Hello,

Great this issue is fixed. Could you please mark your topic as resolved?

Let us know if there is any further help we can give.

Best regards

Sabrina