Support Questions
Find answers, ask questions, and share your expertise

How to create partition tables on external database with spark-shell and JDBC.

Explorer

I would like to create partition tables on external database with spark-shell and JDBC.
I could have created tables with the below command. However I have no idea of creating partition tables.

First of all, can I create partition tables on external database with spark-shell and JDBC ?
If I can create that, please share the command and information with me.

***FYI***

scala> testDF.write format("JDBC").option("driver",driver). option("url",url).option("databaseName",database).option("createTableColumnTypes","id int, name varchar(20)").option("dbtable","SYSTEM.test").option("user",username).option("password",password).save()

Regards