Merge pull request #11788 from ydb-platform/mergelibs-241120-1113

Library import 241120-1113

1 files changed, 33 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/select/host_count.sql b/yql/essentials/tests/sql/suites/select/host_count.sql
new file mode 100644
index 0000000000..eed3d6c9fa
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/select/host_count.sql
@@ -0,0 +1,33 @@
+/* postgres can not */
+USE plato;
+
+$data = (
+    SELECT
+        Url::Normalize(url) AS normalized_url,
+        Url::GetHost(Url::Normalize(url)) AS host,
+        Url::GetDomain(Url::Normalize(url), 1) AS tld
+    FROM CONCAT(
+        `Input1`,
+        `Input2`
+    )
+);
+$ru_hosts = (
+    SELECT
+        tld,
+        host
+    FROM
+        $data
+    WHERE normalized_url IS NOT NULL AND (
+           tld = "ru"
+        OR tld = "su"
+        OR tld = "рф"
+        OR tld = "xn--p1ai" -- punycode рф
+    )
+);
+
+SELECT
+    tld,
+    COUNT(DISTINCT host) AS hosts_count
+FROM $ru_hosts
+GROUP BY tld
+ORDER BY hosts_count DESC;