I am trying to add my customized jar in Azure Synapse Workspace to make use of user defined function (udf) present in the jar while running the sql query in Synapse Notebook.
An Example: There is udf named as MapCloud() registered in UDFHelper.scala file inside the jar. I uploaded my jar (app-assembly-synapse.jar) to Azure Synapse Workspace and then added package to one of my spark pool (Everything2). But when I tried to build a session, the session was getting killed, not sure why.
Questions:
- How can I create a session after adding package to my spark pool.
- How can I make use of udf after the session is getting created.
What I tried: I was able to upload my jar in Workspace Screenshot1
I added the package to my spark pool Screenshot2
I tried to create session but got failed with the error Screenshot3
When I try to execute this Screenshot4, I am getting below error => AnalysisException: Undefined function: 'MapCloud'. This function is neither a registered temporary function nor a permanent function registered in the database 'default'.; line 3 pos 7
Any help would be appreciated, Thanks!
