Vertica Spark Connector error relation does not exist

When saving a Spark DataFrame to Vertica using the HPE Vertica Connector for Apache Spark an error is thrown that the relation does not exist.  

 

The following error message occurs:

java.sql.SQLSyntaxErrorException: [Vertica][VJDBC](4566) ERROR: Relation "S2V_TEMP_TABLE_xyz" does not exist.

 

--This is most likely due to setting the "dbschema" option, and this is an error that will be fixed in the next code update.  For now please do not set the "dbschema" option, and the connector will just default to using the "public" schema only until the next update.  Thank you.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file