StackOverFlow error in JDBC Vertica Driver

I am using sqoop to fetch data from HP Vertica using Vertica's JDBC driver. My Vertica setup has node to node encryption enabled and is on SSL. I have a single mapper that fetches data, and there are more than 300 million rows in the projection. I am encountering following StackOverFlow error while fetching the data: INFO org.apache.sqoop.mapreduce.AutoProgressMapper: Auto-progress thread is finished. keepGoing=false ERROR org.apache.hadoop.mapred.YarnChild: Error running child : java.lang.StackOverflowError at com.vertica.jdbc.common.SPreparedStatement.clearBatch(Unknown Source) at com.vertica.jdbc.VerticaJdbc4PreparedStatementImpl.clearBatch(Unknown Source) at com.vertica.jdbc.common.SPreparedStatement.close(Unknown Source) at com.vertica.jdbc.common.SStatement.checkIfOpen(Unknown Source) at com.vertica.jdbc.common.SPreparedStatement.clearBatch(Unknown Source) at com.vertica.jdbc.VerticaJdbc4PreparedStatementImpl.clearBatch(Unknown Source) at com.vertica.jdbc.common.SPreparedStatement.close(Unknown Source) at com.vertica.jdbc.common.SStatement.checkIfOpen(Unknown Source) at com.vertica.jdbc.common.SPreparedStatement.clearBatch(Unknown Source) at com.vertica.jdbc.VerticaJdbc4PreparedStatementImpl.clearBatch(Unknown Source) at com.vertica.jdbc.common.SPreparedStatement.close(Unknown Source) at com.vertica.jdbc.common.SStatement.checkIfOpen(Unknown Source) at com.vertica.jdbc.common.SPreparedStatement.clearBatch(Unknown Source) at com.vertica.jdbc.VerticaJdbc4PreparedStatementImpl.clearBatch(Unknown Source) at com.vertica.jdbc.common.SPreparedStatement.close(Unknown Source) at com.vertica.jdbc.common.SStatement.checkIfOpen(Unknown Source) at com.vertica.jdbc.common.SPreparedStatement.clearBatch(Unknown Source) at com.vertica.jdbc.VerticaJdbc4PreparedStatementImpl.clearBatch(Unknown Source) at com.vertica.jdbc.common.SPreparedStatement.close(Unknown Source) at com.vertica.jdbc.common.SStatement.checkIfOpen(Unknown Source) at com.vertica.jdbc.common.SPreparedStatement.clearBatch(Unknown Source) at com.vertica.jdbc.VerticaJdbc4PreparedStatementImpl.clearBatch(Unknown Source) My sqoop has split by column and thats a primary key. I have also checked [Vertica's JDBC driver code](https://zgrepcode.com/vertica-jdbc/9.1.1-0/com/vertica/jdbc/) to see if there is a visible recursion that might be causing this StackOverFlow error, but couldn't find one. I have also tested it with different versions of the JDBC driver, but no luck. The version I am using is 9.1.1. Any leads on solving this issue appreciated.
user
11-03-2019 12:19:17 -0400

2 Answers

Hello! This is an open forum for questions related to the Denodo Platform. This issue is related to Sqoop and Vertica. I would suggest you to ask the vendors or open this questions in a forum related to Sqoop or Vertica. Hope this helps!
Denodo Team
11-03-2019 21:32:39 -0400
Okay, thanks.
user
12-03-2019 00:27:32 -0400
You must sign in to add an answer. If you do not have an account, you can register here