Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-29-2022 08:42 AM
Thanks, its working now. But I have got another issue that the data in dataframe save as a new table instead of inserting the data into existing table in DB.
df
.write
.format("jdbc")\
.option("url", jdbcUrl)\
.mode("overwrite")\
.option("dbtable","Driver_DVCSD")\
.option("user", jdbcUsername)\
.option("password", jdbcPassword).save()
The dataframe hold the XML data and the table has audit columns created_date and created_by which is been dropped when the data is written from the dataframe to table.