[ https://issues.apache.org/jira/browse/SPARK-39929?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17573529#comment-17573529 ]
Sun BiaoBiao edited comment on SPARK-39929 at 8/6/22 6:41 AM: -------------------------------------------------------------- ||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| y|n|y|y|y| | | | | | | | | | | | | | | | | | | |char|y|n|y|y|y| | | | | | | | | | | | | | | | | | | |chr|y|n|y|y|y| | | | | | | | | | | | | | | | | | | |contains|n| |n| | | | | | | | | | | | | | | | | | | | | |startswith|n| |n| | | | | | | | | | | | | | | | | | | | | |endswith|n| |n| | | | | | | | | | | | | | | | | | | | | |base64|n| |n| | | | | | | | | | | | | | | | | | | | | |bit_length|y|y|y|y|y| | | | | | | | | | | | | | | | | | | |char_length|y|y|y|y|y| | | | | | | | | | | | | | | | | | | |character_length|y|y|y|y|y| | | | | | | | | | | | | | | | | | | |concat_ws|y|y|y|y|y| | | | | | | | | | | | | | | | | | | |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|y|y|y|y|n| | | | | | | | | | | | | | | | | | | |ltrim|y|y|y|y|y| | | | | | | | | | | | | | | | | | | |json_tuple| | | | | | | | | | | | | | | | | | | | | | | | |position| | | | | | | | | | | | | | | | | | | | | | | | |printf| | | | | | | | | | | | | | | | | | | | | | | | |regexp_extract| | | | | | | | | | | | | | | | | | | | | | | | |regexp_extract_all| | | | | | | | | | | | | | | | | | | | | | | | |regexp_replace| | | | | | | | | | | | | | | | | | | | | | | | |repeat| | | | | | | | | | | | | | | | | | | | | | | | |replace| | | | | | | | | | | | | | | | | | | | | | | | |overlay| | | | | | | | | | | | | | | | | | | | | | | | |rlike| | | | | | | | | | | | | | | | | | | | | | | | |regexp_like| | | | | | | | | | | | | | | | | | | | | | | | |regexp| | | | | | | | | | | | | | | | | | | | | | | | |rpad|y|y|y|y|n| | | | | | | | | | | | | | | | | | | |rtrim|y|y|y|y|y| | | | | | | | | | | | | | | | | | | |sentences| | | | | | | | | | | | | | | | | | | | | | | | |soundex| | | | | | | | | | | | | | | | | | | | | | | | |space| | | | | | | | | | | | | | | | | | | | | | | | |split| | | | | | | | | | | | | | | | | | | | | | | | |split_part| | | | | | | | | | | | | | | | | | | | | | | | |substr| | | | | | | | | | | | | | | | | | | | | | | | |substring| | | | | | | | | | | | | | | | | | | | | | | | |left|y|n|y|y|y| | | | | | | | | | | | | | | | | | | |right|y|n|y|y|y| | | | | | | | | | | | | | | | | | | |substring_index| | | | | | | | | | | | | | | | | | | | | | | | |translate| | | | | | | | | | | | | | | | | | | | | | | | |translate| | | | | | | | | | | | | | | | | | | | | | | | |btrim| | | | | | | | | | | | | | | | | | | | | | | | was (Author: biaobiao.sun): ||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| y|n|y|y|y| | | | | | | | | | | | | | | | | | | |char|y|n|y|y|y| | | | | | | | | | | | | | | | | | | |chr|y|n|y|y|y| | | | | | | | | | | | | | | | | | | |contains|n| |n| | | | | | | | | | | | | | | | | | | | | |startswith|n| |n| | | | | | | | | | | | | | | | | | | | | |endswith|n| |n| | | | | | | | | | | | | | | | | | | | | |base64|n| |n| | | | | | | | | | | | | | | | | | | | | |bit_length|y|y|y|y|y| | | | | | | | | | | | | | | | | | | |char_length|y|y|y|y|y| | | | | | | | | | | | | | | | | | | |character_length|y|y|y|y|y| | | | | | | | | | | | | | | | | | | |concat_ws|y|y|y|y|y| | | | | | | | | | | | | | | | | | | |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|y|y|y|y|n| | | | | | | | | | | | | | | | | | | |ltrim|y|y|y|y|y| | | | | | | | | | | | | | | | | | | |json_tuple| | | | | | | | | | | | | | | | | | | | | | | | |position| | | | | | | | | | | | | | | | | | | | | | | | |printf| | | | | | | | | | | | | | | | | | | | | | | | |regexp_extract| | | | | | | | | | | | | | | | | | | | | | | | |regexp_extract_all| | | | | | | | | | | | | | | | | | | | | | | | |regexp_replace| | | | | | | | | | | | | | | | | | | | | | | | |repeat| | | | | | | | | | | | | | | | | | | | | | | | |replace| | | | | | | | | | | | | | | | | | | | | | | | |overlay| | | | | | | | | | | | | | | | | | | | | | | | |rlike| | | | | | | | | | | | | | | | | | | | | | | | |regexp_like| | | | | | | | | | | | | | | | | | | | | | | | |regexp| | | | | | | | | | | | | | | | | | | | | | | | |rpad|y|y|y|y|n| | | | | | | | | | | | | | | | | | | |rtrim|y|y|y|y|y| | | | | | | | | | | | | | | | | | | |sentences| | | | | | | | | | | | | | | | | | | | | | | | |soundex| | | | | | | | | | | | | | | | | | | | | | | | |space| | | | | | | | | | | | | | | | | | | | | | | | |split| | | | | | | | | | | | | | | | | | | | | | | | |split_part| | | | | | | | | | | | | | | | | | | | | | | | |substr| | | | | | | | | | | | | | | | | | | | | | | | |substring| | | | | | | | | | | | | | | | | | | | | | | | |left|y|n|y|y|y| | | | | | | | | | | | | | | | | | | |right|y|n|y|y|y| | | | | | | | | | | | | | | | | | | |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-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org