Not able load data from postgresql to hdfs using tSqoopImport

Six Stars

Not able load data from postgresql to hdfs using tSqoopImport

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?


Accepted Solutions
Six Stars

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

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


All Replies
Six Stars

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

Your help will be appriciated!

Six Stars

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

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

Moderator

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

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.

1.png

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

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

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

Moderator

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

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

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

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

 

 

Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

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

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

Moderator

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

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.