v.20.5New Feature
Add netloc function for extracting network location in Python style
Addnetlocfunction for extracting network location, similar tourlparse(url),netlocin python. #11356 (Guillaume Tassery).
Why it matters
This feature provides users a simple and reliable way to extract the domain and port information from URLs directly within ClickHouse queries, facilitating URL parsing and analysis without external processing.How to use it
Use thenetloc function by passing a URL string as the argument, for example: sql<br>SELECT netloc('https://example.com:8080/path')<br>. This will return the network location component (e.g., example.com:8080).