Inserting date into ignite with spark jdbc

[Humphrey]

Hello guys this question has been asked on  Stack Overflow
<https://stackoverflow.com/questions/64554684/how-to-create-a-table-with-primary-key-using-jdbc-spark-connector-to-ignite>
  
but yet no answer is a provided.

I'm facing the same issue (trying to insert data in ignite using
spark.jdbc):
Exception in thread "main" java.sql.SQLException: No PRIMARY KEY defined for
CREATE TABLE
        at
org.apache.ignite.internal.jdbc.thin.JdbcThinConnection.sendRequest(JdbcThinConnection.java:1004)

Code:
    println("-- writing using jdbc --")
    val prop = Properties()
    prop["driver"] = "org.apache.ignite.IgniteJdbcThinDriver"

    df.write().apply {
            mode(SaveMode.Overwrite)
            format("jdbc")
            option("url", "jdbc:ignite:thin://127.0.0.1")
            option("dbtable", "comments")
           
option(IgniteDataFrameSettings.OPTION_CREATE_TABLE_PRIMARY_KEY_FIELDS(),
"last_name")
    }.save()

The last option doesn't seem to work/help.



--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/