Apache Presto - url_extract_port(url)

查询

presto:default> select url_extract_port('https://tutorialspoint.com:8080') as port;

结果

 port 
------ 
 8080