Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

Don't have an account?
Coming from Hortonworks? Activate your account here