advancedxy commented on PR #46707: URL: https://github.com/apache/spark/pull/46707#issuecomment-2271453058
> Other ideas welcome. Same scenario applies to UPDATE which also has single table identifier to read from and write to. I noticed SQL Server uses with to specify hints: https://learn.microsoft.com/en-us/sql/t-sql/queries/hints-transact-sql-table?view=sql-server-ver16. We may refer that and design new syntaxes as ```SQL with (options(k1=v1, k2=v2), read(k3=v3, k4=v4), write(k5=v5, k6=v6)) ``` ? However, I think `WITH READ OPTIONS('a', 'b') WRITE OPTIONS ('c', 'd')` is clear and sufficient for read/write options only. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
