Data mapping stops from tHiveinput to VerticaOutput
During data mapping from tHiveInput to tDBOutput the loading becomes slow then stops, I have a hive table containing 900,000 rows, I execute, the loading stops at 150,000 rows, so I changed the parameters of JVM to increase the performance Xms256 to Xms512 and Xmx1024 to Xmx2048, I execute other times but stops at 300,000
So looking at the scenario, it seems like your job still need more JVM memory. You may want to try incrementally increasing the JVM and see at what memory the job finishes normally. Also, you can try using Memory Run feature in studio to understand the execution of job:
