presto:default> select url_extract_path ('http://www.finddevguides.com/hive/hive_installation') as path;
path ----------------------------- /hive/hive_installation