[jira] [Commented] (SPARK-39423) Spark Sql create table using jbdc add preSql option

["Hyukjin Kwon (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SPARK-39423?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17553360#comment-17553360 ] 

Hyukjin Kwon commented on SPARK-39423:
--------------------------------------

There's new option {{prepareQuery}}. I think it does what you're trying to do.

> Spark Sql create table using jbdc add preSql option
> ---------------------------------------------------
>
>                 Key: SPARK-39423
>                 URL: https://issues.apache.org/jira/browse/SPARK-39423
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 3.2.1
>            Reporter: WeiNan Zhao
>            Priority: Major
>         Attachments: image-2022-06-09-10-48-05-347.png
>
>
> In my recent process of using Spark Sql, I tried to use create using jdbc to create a spark table that I need to use, but I may need to consider that before inserting, I need to delete some of the previous data, so I want to be able to expose This option, the use example can refer to the following picture.
> And I can submit a pullrequest to solve this problem. please assign to me. Thanks.
> !image-2022-06-09-10-48-05-347.png!



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org