[Question] how to set MAXDOP

[guoliqiang]

Hi Team,
when I query data from SQL server, if I intent to control the CPU usage, I always use

select * from XXX option (MAXDOP 1)

How to achieve this by spark sql connector?

I tried to pass above query through option("query"), it throws a syntax error.

java.lang.Error: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword 'OPTION'.