abhishekboga commented on PR #28953:
URL: https://github.com/apache/spark/pull/28953#issuecomment-1240017770
Hello everyone, I know this pr has been closed but it would be really
helpful if I get a resolution on the same topic. So here I am trying to call
snowflake procedure in the aws glue job using Pyspark. Below is the code:
df =
spark.read.format(SNOWFLAKE_SOURCE_NAME).options(**sfOptions).option("query",
"call SP_UTILIZATION_INSIGHTS_LOOKUP_TABLE()").option("preActions", "call
SP_UTILIZATION_INSIGHTS_LOOKUP_TABLE()").load()
While execution I'm getting an error as SQL Compilation error: at 'call'.
In the log files what I found is it basically creates a select statement as
'Select * from (call SP_UTILIZATION_INSIGHTS_LOOKUP_TABLE()) where 1=0' and due
to this it failed.
Any help here?
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
