panbingkun commented on PR #47364:
URL: https://github.com/apache/spark/pull/47364#issuecomment-2242344407
> Apart from SQL API, we need to support other APIs as well, which should be
used by calling `Session.catalog.collation`. Because of this, your approach
might need to be reworked a bit.
@mihailom-db
Thank you very much for your reply (`very detailed`). Okay, let's work
together to complete it.
I only have a small question, do we only use one command to display all the
fields in the above list,
### 1.`SHOW COLLATIONS LIKE ....`
|COLLATION_CATALOG|COLLATION_SCHEMA|COLLATION_NAME|LANGUAGE|COUNTRY|ACCENT_SENSITIVITY|CASE_SENSITIVITY|PAD_ATTRIBUTE|ICU_VERSION|
|---|---|---|---|---|---|---|---|---|
|SYSTEM|BUILTIN|UTF8_BINARY|NULL|NULL|ACCENT_SENSITIVE|CASE_SENSITIVITY|NO_PAD|NULL|
|SYSTEM|BUILTIN|UTF8_LCASE|NULL|NULL|ACCENT_SENSITIVE|CASE_INSENSITIVE|NO_PAD|NULL|
|...|...|...|...|...|...|...|...|...|
### 2.or do we use two commands, eg:
A.`SHOW COLLATIONS LIKE ....`
| COLLATION_NAME|
|-----|
|UTF8_BINARY|
|UTF8_LCASE|
|...|
B.`DESCRIBE COLLATION UTF8_BINARY`
|COLLATION_CATALOG|COLLATION_SCHEMA|COLLATION_NAME|LANGUAGE|COUNTRY|ACCENT_SENSITIVITY|CASE_SENSITIVITY|PAD_ATTRIBUTE|ICU_VERSION|
|---|---|---|---|---|---|---|---|---|
|SYSTEM|BUILTIN|UTF8_BINARY|NULL|NULL|ACCENT_SENSITIVE|CASE_SENSITIVITY|NO_PAD|NULL|
Which of the above is more suitable?
--
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: reviews-unsubscr...@spark.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
