URL_EXTRACT_PARAMETER (Lakehouse v2)
从 URL 字符串中提取查询参数的值。
Analyze 语法
Section titled “Analyze 语法”func.url_extract_parameter(<url>, <param>)Analyze 示例
Section titled “Analyze 示例”func.url_extract_parameter('https://example.com?page=1&size=10', 'page')
┌─────┐│ '1' │└─────┘SQL 语法
Section titled “SQL 语法”URL_EXTRACT_PARAMETER(<url>, <param>)SQL 示例
Section titled “SQL 示例”SELECT URL_EXTRACT_PARAMETER('https://example.com?page=1&size=10', 'page');
┌───┐│ 1 │└───┘