HIVE SQL代码:
substring_index(parse_url(referrer,'HOST'),'.',-2) refer_host
java代码:
import java.net.URI;
try {
String host = new URI(referrer).getHost();
String[] hostSplit = host.split("\\.");
if (hostSplit.length >= 2) {
System.out.println(hostSplit[hostSplit.length - 2] + "." + hostSplit[hostSplit.length - 1]);
} else {
System.out.println(String.join(".", hostSplit));
}
} catch (Exception e) {
logger.debug("refer parse error:{}", e);
}