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.
