split_part(string,delimiter,index)

查询

presto:default> select split_part('apache presto’,'p',2); 

 _col0 
------- 
 ache

apache_presto_sql_functions.html