我试图在没有scheme的情况下从url中提取主机名和路径,但parse_url不起作用。我还有什么其他选择?
PARSE_URL在没有方案-的情况下不起作用
SNOWFLAKE1#COMPUTE_WH@TEST_DB.PUBLIC>SELECT PARSE_URL('www.snowflake.com');
100139 (22000): Error parsing URL: scheme not specified
SNOWFLAKE1#COMPUTE_WH@TEST_DB.PUBLIC>SELECT PARSE_URL('http://www.snowflake.com');
+---------------------------------------+
| PARSE_URL('HTTP://WWW.SNOWFLAKE.COM') |
|---------------------------------------|
| { |
| "fragment": null, |
| "host": "www.snowflake.com", |
| "parameters": null, |
| "path": null, |
| "port": null, |
| "query": null, |
| "scheme": "http" |
| } |
+---------------------------------------+
1 Row(s) produced. Time Elapsed: 0.229s
想知道你是否正在寻找下面这样的东西-
通过分隔符将一列拆分为多列,并使用SQL 从最后一列重新组合到第一列
SNOWFLAKE1#COMPUTE_WH@TEST_DB.PUBLIC>select value from table(split_to_table('com.dqm.abcv.xyz.google', '.'));
+--------+
| VALUE |
|--------|
| com |
| dqm |
| abcv |
| xyz |
| google |
+--------+
5 Row(s) produced. Time Elapsed: 0.566s