Not able load data from postgresql to hdfs using tSqoopImport

[Vishu1]

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?

[Vishu1]

Your help will be appriciated!

[Vishu1]

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

[Anonymous]

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

[Vishu1]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[Vishu1]

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

[Anonymous]

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

[Vishu1 · Accepted solution]

@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.

[Anonymous]

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