Running SQL Statements other than SELECT, using Spark/JDBC Connector

[ghifariram]

Hi guys,

Is there any way to run the SQL statements other than SELECT, like ALTER, DELETE etc using Spark or JDBC Connector?

I am aware that we can do SELECT statement using dbtable options and call sqlContext.read.format("jdbc").options(options).load(), but I don't know if it is also works for any other statements.

What I'm trying to do is to overwrite the data in Kinetica based on certain conditions in a specific column other than the primary key, so I need to run the DELETE statement first before I insert the data.

Jar version that I am using: kinetica-spark-7.0.6.1-jar-with-dependencies.jar