GitHub user hvanhovell opened a pull request:
https://github.com/apache/spark/pull/13929
[SPARK-16220][SQL] Add scope to show functions
## What changes were proposed in this pull request?
Spark currently shows all functions when issue a `SHOW FUNCTIONS` command.
This PR refines the `SHOW FUNCTIONS` command by allowing users to select all
functions, user defined function or system functions. The following syntax can
be used:
**ALL** (default)
```sql SHOW FUNCTIONS```
```sql SHOW ALL FUNCTIONS```
**SYSTEM**
```sql SHOW SYSTEM FUNCTIONS```
**USER**
```sql SHOW USER FUNCTIONS```
## How was this patch tested?
Updated tests and added tests to the DDLSuite
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/hvanhovell/spark SPARK-16220
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/spark/pull/13929.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 #13929
----
commit d33f1444115415db876af773cb15def456d0df32
Author: Herman van Hovell <[email protected]>
Date: 2016-06-27T18:52:10Z
Add identifier to show functions.
commit 8c6189b4fc3c43e732d8a1dcbf09be451f212562
Author: Herman van Hovell <[email protected]>
Date: 2016-06-27T18:52:26Z
Merge remote-tracking branch 'apache-github/master' into SPARK-16220
commit 8dde044b4a30fb6d1a040d7315c0c97d2c30e048
Author: Herman van Hovell <[email protected]>
Date: 2016-06-27T19:52:01Z
Add scope to functions
----
---
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]
