[GitHub] [spark] peter-toth commented on pull request #28953: [SPARK-32013][SQL] Support query execution before reading DataFrame and before/after writing DataFrame over JDBC

[GitBox <gi...@apache.org>]

peter-toth commented on PR #28953:
URL: https://github.com/apache/spark/pull/28953#issuecomment-1240522843

   This was my PR: https://github.com/apache/spark/pull/36440, but I'm not sure it helps in this case as the new `prepareQuery` property becomes part of the statement sent to the server, while in this case the stored procedure call (`.option("preActions", "call SP_UTILIZATION_INSIGHTS_LOOKUP_TABLE()"`) should be a separete statement.
   
   @abhishekboga, I think you could probaly use the `sessionInitStatement` property to call the stored procedure before running your query...


-- 
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-unsubscribe@spark.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


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