[
https://issues.apache.org/jira/browse/SPARK-14429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bo Meng updated SPARK-14429:
----------------------------
Description:
LIKE <pattern> is commonly used in {code:SQL} SHOW TABLES / FUNCTIONS {code}
etc DDL. In the pattern, user can use `|` or `\*` as wildcards.
I'd like to address a few issues in this JIRA:
# Currently, we used `replaceAll()` to replace `\*` with `.\*`, but the
replacement was scattered in several places; it is good to have one place to do
the same thing;
# Consistency with Hive: the pattern is case insensitive in Hive and white
spaces will be trimmed, but current pattern matching does not do that. For
example, suppose we have tables (t1, t2, t3), {code:SQL}SHOW TABLES LIKE ' T*
'; {code} will list all the t-tables.
# Sort the result.
Please use Hive to verify it.
was:
LIKE <pattern> is commonly used in {code:SQL} SHOW TABLES / FUNCTIONS {code}
etc DDL. In the pattern, user can use `|` or `\*` as wildcards.
I'd like to address a few issues in this JIRA:
# Currently, we used `replaceAll()` to replace `\*` with `.\*`, but the
replacement was scattered in several places; it is good to have one place to do
the same thing;
# Consistency with Hive: the pattern is case insensitive in Hive and white
spaces will be trimmed, but current pattern matching does not do that. For
example, suppose we have tables (t1, t2, t3), {code:SQL}SHOW TABLES LIKE ' T*
'; {code} will list all the t-tables. Please use Hive to verify it.
> Revisit LIKE pattern in "SHOW TABLES / FUNCTIONS LIKE <pattern>" DDL
> --------------------------------------------------------------------
>
> Key: SPARK-14429
> URL: https://issues.apache.org/jira/browse/SPARK-14429
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Reporter: Bo Meng
> Priority: Minor
>
> LIKE <pattern> is commonly used in {code:SQL} SHOW TABLES / FUNCTIONS {code}
> etc DDL. In the pattern, user can use `|` or `\*` as wildcards.
> I'd like to address a few issues in this JIRA:
> # Currently, we used `replaceAll()` to replace `\*` with `.\*`, but the
> replacement was scattered in several places; it is good to have one place to
> do the same thing;
> # Consistency with Hive: the pattern is case insensitive in Hive and white
> spaces will be trimmed, but current pattern matching does not do that. For
> example, suppose we have tables (t1, t2, t3), {code:SQL}SHOW TABLES LIKE '
> T* '; {code} will list all the t-tables.
> # Sort the result.
> Please use Hive to verify it.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
