You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Sun BiaoBiao (Jira)" <ji...@apache.org> on 2022/08/01 03:53:00 UTC
[jira] [Commented] (SPARK-39929) DS V2 supports push down string functions(non ANSI)
[ https://issues.apache.org/jira/browse/SPARK-39929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17573529#comment-17573529 ]
Sun BiaoBiao commented on SPARK-39929:
--------------------------------------
||Function name||PostgreSQL||ClickHouse||H2||MySQL||Oracle||Redshift||Presto||Teradata||Snowflake||DB2||Vertica||Exasol||SqlServer||Yellowbrick||Impala||Mariadb||Druid||Pig||Singlestore||ElasticSearch||SQLite||Influxdata||Sybase||
|ascii| | | | | | | | | | | | | | | | | | | | | | | |
|char| | | | | | | | | | | | | | | | | | | | | | | |
|chr| | | | | | | | | | | | | | | | | | | | | | | |
|contains| | | | | | | | | | | | | | | | | | | | | | | |
|startswith| | | | | | | | | | | | | | | | | | | | | | | |
|endswith| | | | | | | | | | | | | | | | | | | | | | | |
|base64| | | | | | | | | | | | | | | | | | | | | | | |
|bit_length| | | | | | | | | | | | | | | | | | | | | | | |
|char_length| | | | | | | | | | | | | | | | | | | | | | | |
|character_length| | | | | | | | | | | | | | | | | | | | | | | |
|concat_ws| | | | | | | | | | | | | | | | | | | | | | | |
|decode| | | | | | | | | | | | | | | | | | | | | | | |
|elt| | | | | | | | | | | | | | | | | | | | | | | |
|encode| | | | | | | | | | | | | | | | | | | | | | | |
|find_in_set| | | | | | | | | | | | | | | | | | | | | | | |
|format_number| | | | | | | | | | | | | | | | | | | | | | | |
|format_string| | | | | | | | | | | | | | | | | | | | | | | |
|to_number| | | | | | | | | | | | | | | | | | | | | | | |
|try_to_number| | | | | | | | | | | | | | | | | | | | | | | |
|to_char| | | | | | | | | | | | | | | | | | | | | | | |
|get_json_object| | | | | | | | | | | | | | | | | | | | | | | |
|initcap| | | | | | | | | | | | | | | | | | | | | | | |
|instr| | | | | | | | | | | | | | | | | | | | | | | |
|lcase| | | | | | | | | | | | | | | | | | | | | | | |
|length| | | | | | | | | | | | | | | | | | | | | | | |
|levenshtein| | | | | | | | | | | | | | | | | | | | | | | |
|like| | | | | | | | | | | | | | | | | | | | | | | |
|ilike| | | | | | | | | | | | | | | | | | | | | | | |
|octet_length| | | | | | | | | | | | | | | | | | | | | | | |
|locate| | | | | | | | | | | | | | | | | | | | | | | |
|lpad| | | | | | | | | | | | | | | | | | | | | | | |
|ltrim| | | | | | | | | | | | | | | | | | | | | | | |
|json_tuple| | | | | | | | | | | | | | | | | | | | | | | |
|position| | | | | | | | | | | | | | | | | | | | | | | |
|printf| | | | | | | | | | | | | | | | | | | | | | | |
|regexp_extract| | | | | | | | | | | | | | | | | | | | | | | |
|regexp_extract_all| | | | | | | | | | | | | | | | | | | | | | | |
|regexp_replace| | | | | | | | | | | | | | | | | | | | | | | |
|repeat| | | | | | | | | | | | | | | | | | | | | | | |
|replace| | | | | | | | | | | | | | | | | | | | | | | |
|overlay| | | | | | | | | | | | | | | | | | | | | | | |
|rlike| | | | | | | | | | | | | | | | | | | | | | | |
|regexp_like| | | | | | | | | | | | | | | | | | | | | | | |
|regexp| | | | | | | | | | | | | | | | | | | | | | | |
|rpad| | | | | | | | | | | | | | | | | | | | | | | |
|rtrim| | | | | | | | | | | | | | | | | | | | | | | |
|sentences| | | | | | | | | | | | | | | | | | | | | | | |
|soundex| | | | | | | | | | | | | | | | | | | | | | | |
|space| | | | | | | | | | | | | | | | | | | | | | | |
|split| | | | | | | | | | | | | | | | | | | | | | | |
|split_part| | | | | | | | | | | | | | | | | | | | | | | |
|substr| | | | | | | | | | | | | | | | | | | | | | | |
|substring| | | | | | | | | | | | | | | | | | | | | | | |
|left| | | | | | | | | | | | | | | | | | | | | | | |
|right| | | | | | | | | | | | | | | | | | | | | | | |
|substring_index| | | | | | | | | | | | | | | | | | | | | | | |
|translate| | | | | | | | | | | | | | | | | | | | | | | |
|translate| | | | | | | | | | | | | | | | | | | | | | | |
|btrim| | | | | | | | | | | | | | | | | | | | | | | |
> DS V2 supports push down string functions(non ANSI)
> ----------------------------------------------------
>
> Key: SPARK-39929
> URL: https://issues.apache.org/jira/browse/SPARK-39929
> Project: Spark
> Issue Type: Sub-task
> Components: SQL
> Affects Versions: 3.4.0
> Reporter: Sun BiaoBiao
> Priority: Major
>
> Currently, Spark have a lot string functions which is not defined in ANSI standard.
> But these functions is commonly used.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org