GitHub user gatorsmile opened a pull request:
https://github.com/apache/spark/pull/18146
[SPARK-20924] [SQL] Unable to call the function registered in the
not-current database
### What changes were proposed in this pull request?
We are unable to call the function registered in the not-current database.
```Scala
sql("CREATE DATABASE dAtABaSe1")
sql(s"CREATE FUNCTION dAtABaSe1.test_avg AS
'${classOf[GenericUDAFAverage].getName}'")
sql("SELECT dAtABaSe1.test_avg(1)")
```
The above code returns an error:
```
Undefined function: 'dAtABaSe1.test_avg'. This function is neither a
registered temporary function nor a permanent function registered in the
database 'default'.; line 1 pos 7
```
This PR is to fix the above issue.
## How was this patch tested?
Added test cases.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gatorsmile/spark qualifiedFunction
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/spark/pull/18146.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #18146
----
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
