You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "Runkang He (Jira)" <ji...@apache.org> on 2023/07/07 13:49:00 UTC

[jira] [Created] (CALCITE-5820) Add PARSE_URL function (enabled in Hive and Spark library)

Runkang He created CALCITE-5820:
-----------------------------------

             Summary: Add PARSE_URL function (enabled in Hive and Spark library)
                 Key: CALCITE-5820
                 URL: https://issues.apache.org/jira/browse/CALCITE-5820
             Project: Calcite
          Issue Type: New Feature
          Components: core
    Affects Versions: 1.34.0
            Reporter: Runkang He


Add PARSE_URL (enabled in Hive and Spark library):

PARSE_URL: Returns the specified part from the URL. Valid values for partToExtract include HOST, PATH, QUERY, REF, PROTOCOL, AUTHORITY, FILE, and USERINFO.

For example, parse_url('http://facebook.com/path1/p.php?k1=v1&k2=v2#Ref1', 'HOST') returns 'facebook.com'.

See more details in [Hive|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf#LanguageManualUDF-StringFunctions] and [Spark|https://spark.apache.org/docs/latest/api/sql/index.html#parse_url] doc.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)