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.
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()