panbingkun opened a new pull request, #47364:
URL: https://github.com/apache/spark/pull/47364
### What changes were proposed in this pull request?
The pr aims to introduce `SHOW COLLATIONS LIKE ...` syntax to `show all
collations`.
### Why are the changes needed?
<!--
Please clarify why the changes are needed. For instance,
1. If you propose a new API, clarify the use case for a new API.
2. If you fix a bug, you can clarify why it is a bug.
-->
### Does this PR introduce _any_ user-facing change?
Yes, end-users will be able to obtain `collation` currently supported by the
spark through commands similar to the following
```
spark-sql (default)> SHOW COLLATIONS;
UTF8_BINARY spark 1.0 true true false
UTF8_LCASE spark 1.0 false false true
ff_Adlm icu 153.120.0.0 false false false
ff_Adlm_CI icu 153.120.0.0 false false false
ff_Adlm_AI icu 153.120.0.0 false false false
ff_Adlm_CI_AI icu 153.120.0.0 false false false
...
spark-sql (default)> SHOW COLLATIONS LIKE '*UTF8_BINARY*';
UTF8_BINARY spark 1.0 true true false
Time taken: 0.043 seconds, Fetched 1 row(s)
```
### How was this patch tested?
Add new UT.
### Was this patch authored or co-authored using generative AI tooling?
No.
--
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]
