waitingkuo commented on issue #2902:
URL:
https://github.com/apache/arrow-datafusion/issues/2902#issuecomment-1203700141
@andygrove
after update datafusion-cli to master version
1-36 passed
37-42 passed but it's incorrect
43 failed
the issues from 37-42 are the same
```
37. SELECT "URL", COUNT(*) AS PageViews FROM hits WHERE "CounterID" = 62 AND
"EventDate" >= '2013-07-01' AND "EventDate" <= '2013-07-31' AND "DontCountHits"
= 0 AND "IsRefresh" = 0 AND "URL" <> '' GROUP BY "URL" ORDER BY PageViews DESC
LIMIT 10;
```
this is the v10.0.0 datafusion-cli result:
```bash
DataFusion CLI v10.0.0
0 rows in set. Query took 0.091 seconds.
Plan("'UInt16 >= Utf8' can't be evaluated because there isn't a common type
to coerce the types to")
```
the original EventDate field is integer; since datafusion-cli doesnt support
schema for reading external parquet, it can't be parsed as date or timestamp
for now. our benchmark codes are modified from clickbench-local as it's
behavior is the most similar one, it does support creating table from parquet
with schema
<https://github.com/ClickHouse/ClickBench/blob/main/clickhouse-local/create.sql#L8>
so it works.
we can't parses it as date or time so it becomes a uint16, which isn't
allowed to compare to utf8. master branch's datafusion-cli does support the
comparison between Uint16 and Utf8 but it looks like that Uint16 is always less
than any Utf8 string so this query return 0 rows
37-42 has the same issues. I think 43 got the similar issue as well.
Things we might need to pass all the cases:
1. support schema while creating external table from parquet
2. `to_timestamp` should work for double quoted string as column name. i
can't do `to_timestamp("EventDate")` here as `to_timestamp` thought EventDate
is a Utf-8.
3. support comparison between timestamp and string so that we can do
`to_timestamp("EventDate") > '2000-01-01'`
``` bash
-----------------------------------------
1. SELECT COUNT(*) FROM hits;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.458 seconds.
+-----------------+
| COUNT(UInt8(1)) |
+-----------------+
| 99997497 |
+-----------------+
1 row in set. Query took 26.038 seconds.
-----------------------------------------
4. SELECT COUNT(*) FROM hits WHERE "AdvEngineID" <> 0;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.434 seconds.
+-----------------+
| COUNT(UInt8(1)) |
+-----------------+
| 630500 |
+-----------------+
1 row in set. Query took 11.491 seconds.
-----------------------------------------
5. SELECT SUM("AdvEngineID"), COUNT(*), AVG("ResolutionWidth") FROM hits;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.429 seconds.
+-----------------------+-----------------+---------------------------+
| SUM(hits.AdvEngineID) | COUNT(UInt8(1)) | AVG(hits.ResolutionWidth) |
+-----------------------+-----------------+---------------------------+
| 7280088 | 99997497 | 1513.4879349030107 |
+-----------------------+-----------------+---------------------------+
1 row in set. Query took 29.987 seconds.
-----------------------------------------
6. SELECT AVG("UserID") FROM hits;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.445 seconds.
+---------------------+
| AVG(hits.UserID) |
+---------------------+
| 2528953029789716000 |
+---------------------+
1 row in set. Query took 18.101 seconds.
-----------------------------------------
7. SELECT COUNT(DISTINCT "UserID") FROM hits;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.466 seconds.
^C%
➜ datafusion
git:(datafusion) ✗ bash run2.sh
-----------------------------------------
1. SELECT COUNT(*) FROM hits;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.043 seconds.
+-----------------+
| COUNT(UInt8(1)) |
+-----------------+
| 99997497 |
+-----------------+
1 row in set. Query took 0.388 seconds.
-----------------------------------------
3. SELECT COUNT(*) FROM hits WHERE "AdvEngineID" <> 0;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.042 seconds.
+-----------------+
| COUNT(UInt8(1)) |
+-----------------+
| 630500 |
+-----------------+
1 row in set. Query took 0.344 seconds.
-----------------------------------------
4. SELECT SUM("AdvEngineID"), COUNT(*), AVG("ResolutionWidth") FROM hits;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.047 seconds.
+-----------------------+-----------------+---------------------------+
| SUM(hits.AdvEngineID) | COUNT(UInt8(1)) | AVG(hits.ResolutionWidth) |
+-----------------------+-----------------+---------------------------+
| 7280088 | 99997497 | 1513.4879349030107 |
+-----------------------+-----------------+---------------------------+
1 row in set. Query took 0.939 seconds.
-----------------------------------------
5. SELECT AVG("UserID") FROM hits;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.039 seconds.
+---------------------+
| AVG(hits.UserID) |
+---------------------+
| 2528953029789716500 |
+---------------------+
1 row in set. Query took 0.542 seconds.
-----------------------------------------
6. SELECT COUNT(DISTINCT "UserID") FROM hits;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.039 seconds.
+-----------------------------+
| COUNT(DISTINCT hits.UserID) |
+-----------------------------+
| 17630976 |
+-----------------------------+
1 row in set. Query took 3.781 seconds.
-----------------------------------------
8. SELECT COUNT(DISTINCT "SearchPhrase") FROM hits;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.043 seconds.
+-----------------------------------+
| COUNT(DISTINCT hits.SearchPhrase) |
+-----------------------------------+
| 6019103 |
+-----------------------------------+
1 row in set. Query took 4.911 seconds.
-----------------------------------------
9. SELECT MIN("EventDate"), MAX("EventDate") FROM hits;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.043 seconds.
+---------------------+---------------------+
| MIN(hits.EventDate) | MAX(hits.EventDate) |
+---------------------+---------------------+
| 15888 | 15917 |
+---------------------+---------------------+
1 row in set. Query took 0.411 seconds.
-----------------------------------------
10. SELECT "AdvEngineID", COUNT(*) FROM hits WHERE "AdvEngineID" <> 0 GROUP
BY "AdvEngineID" ORDER BY COUNT(*) DESC;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.039 seconds.
+-------------+-----------------+
| AdvEngineID | COUNT(UInt8(1)) |
+-------------+-----------------+
| 2 | 404602 |
| 27 | 113167 |
| 13 | 45631 |
| 45 | 38960 |
| 44 | 9730 |
| 3 | 6896 |
| 62 | 5266 |
| 52 | 3554 |
| 50 | 938 |
| 28 | 836 |
| 53 | 350 |
| 25 | 343 |
| 61 | 158 |
| 21 | 38 |
| 42 | 20 |
| 16 | 7 |
| 7 | 3 |
| 22 | 1 |
+-------------+-----------------+
18 rows in set. Query took 0.349 seconds.
-----------------------------------------
11. SELECT "RegionID", COUNT(DISTINCT "UserID") AS u FROM hits GROUP BY
"RegionID" ORDER BY u DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.040 seconds.
+----------+---------+
| RegionID | u |
+----------+---------+
| 229 | 2845673 |
| 2 | 1081016 |
| 208 | 831676 |
| 169 | 604583 |
| 184 | 322661 |
| 158 | 307152 |
| 34 | 299479 |
| 55 | 286525 |
| 107 | 272448 |
| 42 | 243181 |
+----------+---------+
10 rows in set. Query took 4.621 seconds.
-----------------------------------------
12. SELECT "RegionID", SUM("AdvEngineID"), COUNT(*) AS c,
AVG("ResolutionWidth"), COUNT(DISTINCT "UserID") FROM hits GROUP BY "RegionID"
ORDER BY c DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.045 seconds.
+----------+-----------------------+----------+---------------------------+-----------------------------+
| RegionID | SUM(hits.AdvEngineID) | c | AVG(hits.ResolutionWidth) |
COUNT(DISTINCT hits.UserID) |
+----------+-----------------------+----------+---------------------------+-----------------------------+
| 229 | 2077656 | 18295832 | 1506.085243130785 |
2845673 |
| 2 | 441662 | 6687587 | 1479.8386542111527 |
1081016 |
| 208 | 285925 | 4261812 | 1285.2593246722286 |
831676 |
| 169 | 100887 | 3320229 | 1465.9073732564832 |
604583 |
| 32 | 81498 | 1843518 | 1538.0376568061718 |
216010 |
| 34 | 161779 | 1792369 | 1548.360152401654 |
299479 |
| 184 | 55526 | 1755192 | 1506.8082967561384 |
322661 |
| 42 | 108820 | 1542717 | 1587.1085208758313 |
243181 |
| 107 | 120470 | 1516690 | 1548.6028970982863 |
272448 |
| 51 | 98212 | 1435578 | 1579.8860354505293 |
211505 |
+----------+-----------------------+----------+---------------------------+-----------------------------+
10 rows in set. Query took 6.048 seconds.
-----------------------------------------
13. SELECT "MobilePhoneModel", COUNT(DISTINCT "UserID") AS u FROM hits WHERE
"MobilePhoneModel" <> '' GROUP BY "MobilePhoneModel" ORDER BY u DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.052 seconds.
+------------------+---------+
| MobilePhoneModel | u |
+------------------+---------+
| iPad | 1090347 |
| iPhone | 45758 |
| A500 | 16046 |
| N8-00 | 5565 |
| iPho | 3300 |
| ONE TOUCH 6030A | 2759 |
| GT-P7300B | 1907 |
| 3110000 | 1871 |
| GT-I9500 | 1598 |
| eagle75 | 1492 |
+------------------+---------+
10 rows in set. Query took 1.882 seconds.
-----------------------------------------
14. SELECT "MobilePhone", "MobilePhoneModel", COUNT(DISTINCT "UserID") AS u
FROM hits WHERE "MobilePhoneModel" <> '' GROUP BY "MobilePhone",
"MobilePhoneModel" ORDER BY u DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.052 seconds.
+-------------+------------------+--------+
| MobilePhone | MobilePhoneModel | u |
+-------------+------------------+--------+
| 1 | iPad | 931038 |
| 5 | iPad | 48385 |
| 6 | iPad | 29710 |
| 7 | iPad | 28391 |
| 118 | A500 | 16005 |
| 6 | iPhone | 14516 |
| 26 | iPhone | 13566 |
| 10 | iPad | 11433 |
| 32 | iPad | 9503 |
| 13 | iPad | 9417 |
+-------------+------------------+--------+
10 rows in set. Query took 2.330 seconds.
-----------------------------------------
15. SELECT "SearchPhrase", COUNT(*) AS c FROM hits WHERE "SearchPhrase" <>
'' GROUP BY "SearchPhrase" ORDER BY c DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.052 seconds.
+---------------------------+-------+
| SearchPhrase | c |
+---------------------------+-------+
| карелки | 70263 |
| албатрутдин | 34675 |
| смотреть онлайн | 24580 |
| смотреть онлайн бесплатно | 21647 |
| смотреть | 19707 |
| мангу в зарабей грама | 19195 |
| дружке помещение | 17284 |
| galaxy table | 16746 |
| экзоидные | 16620 |
| сколько мытищи | 12317 |
+---------------------------+-------+
10 rows in set. Query took 6.174 seconds.
-----------------------------------------
16. SELECT "SearchPhrase", COUNT(DISTINCT "UserID") AS u FROM hits WHERE
"SearchPhrase" <> '' GROUP BY "SearchPhrase" ORDER BY u DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.057 seconds.
+---------------------------+-------+
| SearchPhrase | u |
+---------------------------+-------+
| карелки | 23673 |
| смотреть онлайн | 19747 |
| албатрутдин | 18394 |
| смотреть онлайн бесплатно | 17553 |
| смотреть | 14603 |
| экзоидные | 14529 |
| мангу в зарабей грама | 14198 |
| сколько мытищи | 9007 |
| дружке помещение | 8792 |
| комбинирование смотреть | 7572 |
+---------------------------+-------+
10 rows in set. Query took 10.028 seconds.
-----------------------------------------
17. SELECT "SearchEngineID", "SearchPhrase", COUNT(*) AS c FROM hits WHERE
"SearchPhrase" <> '' GROUP BY "SearchEngineID", "SearchPhrase" ORDER BY c DESC
LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.061 seconds.
+----------------+---------------------------+-------+
| SearchEngineID | SearchPhrase | c |
+----------------+---------------------------+-------+
| 2 | карелки | 46258 |
| 2 | мангу в зарабей грама | 18871 |
| 2 | смотреть онлайн | 16905 |
| 3 | албатрутдин | 16748 |
| 2 | смотреть онлайн бесплатно | 14909 |
| 2 | албатрутдин | 13716 |
| 2 | экзоидные | 13414 |
| 2 | смотреть | 13108 |
| 3 | карелки | 12815 |
| 2 | дружке помещение | 11946 |
+----------------+---------------------------+-------+
10 rows in set. Query took 7.919 seconds.
-----------------------------------------
18. SELECT "UserID", COUNT(*) FROM hits GROUP BY "UserID" ORDER BY COUNT(*)
DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.061 seconds.
+---------------------+-----------------+
| UserID | COUNT(UInt8(1)) |
+---------------------+-----------------+
| 1313338681122956954 | 29097 |
| 1907779576417363396 | 25333 |
| 2305303682471783379 | 10597 |
| 7982623143712728547 | 7584 |
| 6018350421959114808 | 6678 |
| 7280399273658728997 | 6411 |
| 1090981537032625727 | 6197 |
| 5730251990344211405 | 6019 |
| 835157184735512989 | 5211 |
| 770542365400669095 | 4906 |
+---------------------+-----------------+
10 rows in set. Query took 7.671 seconds.
-----------------------------------------
19. SELECT "UserID", "SearchPhrase", COUNT(*) FROM hits GROUP BY "UserID",
"SearchPhrase" ORDER BY COUNT(*) DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.072 seconds.
+---------------------+--------------+-----------------+
| UserID | SearchPhrase | COUNT(UInt8(1)) |
+---------------------+--------------+-----------------+
| 1313338681122956954 | | 29097 |
| 1907779576417363396 | | 25333 |
| 2305303682471783379 | | 10597 |
| 7982623143712728547 | | 6669 |
| 7280399273658728997 | | 6408 |
| 1090981537032625727 | | 6196 |
| 5730251990344211405 | | 6019 |
| 6018350421959114808 | | 5990 |
| 835157184735512989 | | 5209 |
| 770542365400669095 | | 4906 |
+---------------------+--------------+-----------------+
10 rows in set. Query took 17.733 seconds.
-----------------------------------------
20. SELECT "UserID", "SearchPhrase", COUNT(*) FROM hits GROUP BY "UserID",
"SearchPhrase" LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.080 seconds.
+--------------------+-----------------------------------+-----------------+
| UserID | SearchPhrase | COUNT(UInt8(1)) |
+--------------------+-----------------------------------+-----------------+
| 551197320963382044 | | 18 |
| 555355732403153904 | | 2 |
| 556853849480989303 | | 3 |
| 558001499068813267 | | 9 |
| 559163664148587221 | | 83 |
| 559664328086679566 | | 14 |
| 559796116809734572 | | 28 |
| 560776637071180173 | | 2 |
| 562221816808008810 | | 2 |
| 563196250018002684 | снять жидкості на за косметаллище | 2 |
+--------------------+-----------------------------------+-----------------+
10 rows in set. Query took 13.977 seconds.
-----------------------------------------
21. SELECT "UserID", extract(minute FROM "EventTime") AS m, "SearchPhrase",
COUNT(*) FROM hits GROUP BY "UserID", m, "SearchPhrase" ORDER BY COUNT(*) DESC
LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.079 seconds.
Plan("Coercion from [Utf8, Int64] to the signature OneOf([Exact([Utf8,
Date32]), Exact([Utf8, Date64]), Exact([Utf8, Timestamp(Second, None)]),
Exact([Utf8, Timestamp(Microsecond, None)]), Exact([Utf8,
Timestamp(Millisecond, None)]), Exact([Utf8, Timestamp(Nanosecond, None)])])
failed.")
-----------------------------------------
22. SELECT "UserID" FROM hits WHERE "UserID" = 435090932899640449;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.080 seconds.
+--------------------+
| UserID |
+--------------------+
| 435090932899640449 |
| 435090932899640449 |
| 435090932899640449 |
| 435090932899640449 |
+--------------------+
4 rows in set. Query took 0.850 seconds.
-----------------------------------------
23. SELECT COUNT(*) FROM hits WHERE "URL" LIKE '%google%';
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.078 seconds.
+-----------------+
| COUNT(UInt8(1)) |
+-----------------+
| 15908 |
+-----------------+
1 row in set. Query took 16.751 seconds.
-----------------------------------------
24. SELECT "SearchPhrase", MIN("URL"), COUNT(*) AS c FROM hits WHERE "URL"
LIKE '%google%' AND "SearchPhrase" <> '' GROUP BY "SearchPhrase" ORDER BY c
DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.068 seconds.
+-------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------+----+
| SearchPhrase |
MIN(hits.URL)
| c |
+-------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------+----+
| прокур горбуши |
http://smeshariki.ru/googleTBR%26ad
| 60 |
| римском качественны for cry |
http:%2F%2Fwwww.googlead&aktional
| 24 |
| стоит похуден |
http://smeshariki.ru/index.ua/doc/22229/googlead%26aktion=2&input_bdsmpeople.ru/real-estate=0&state=2013070519381
| 23 |
| испанч боб новости дейская |
http://smeshariki.ru/recipes/show/6840872&trafkey=6d0fc12c54059/loukhaAUXI&where=all&filter/Mitsubishi/google
| 21 |
| прокур готовки видеоэндоменя |
http://smeshariki.ru/googleTBR%26ad
| 14 |
| прокур гипоаллеры |
http://smeshariki.ru/googleTBR%26ad
| 11 |
| камедицинск автомобильних условодки на в крем |
http://video.yandex.php?com=google.ru/arts/searchAutoSearch
| 9 |
| универ 11.6/1366x768/4096mb ddressary of thing |
http://smeshariki.ru/index.ua/syllanet.ru/business/hotels.turizm.ru/igooglead%26ar_sliceid%3D1216629/0/&&puid2=15&lo=http
| 8 |
| вспомню о названы монстэр |
http://tienskaia-moda-zhienskaia-obl.irr.ru/ch/google-c-38208
| 7 |
| купить трудовані резюме мертный дина кабинский лежит заднее устан |
http://video.yandex.php?com=google.ru/arts/searchAutoSearch
| 7 |
+-------------------------------------------------------------------+---------------------------------------------------------------------------------------------------------------------------+----+
10 rows in set. Query took 16.723 seconds.
-----------------------------------------
25. SELECT "SearchPhrase", MIN("URL"), MIN("Title"), COUNT(*) AS c,
COUNT(DISTINCT "UserID") FROM hits WHERE "Title" LIKE '%Google%' AND "URL" NOT
LIKE '%.google.%' AND "SearchPhrase" <> '' GROUP BY "SearchPhrase" ORDER BY c
DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.051 seconds.
+--------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----+-----------------------------+
| SearchPhrase | MIN(hits.URL)
| MIN(hits.Title)
| c | COUNT(DISTINCT hits.UserID) |
+--------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----+-----------------------------+
| винки медведь смотреть фильмы 2013 смотреть |
http://smeshariki.ru/a-folder-4/#page-3.2.1; WOW64;
Edition=1&input_action=2011/page_type=profiles/88436/currency
|
видеорегионалу Google
| 801 | 600
|
| секретарь оверка все серии порт |
http://kinopoisk.ru/a-albums_scroll_to_auto_id=227&option/vacancies/liver.ru/cgi-bin/click.cgi%3Fsid%3D158197%26ad
| @дневники Google Player 1.2.5 л,
| 214 |
182 |
| винки медведь смотреть фильмы чеческия |
http://smeshariki.ru/a-folder-4/#page-3.2.1; WOW64;
Edition=1&input_action=2013-topy%2Fproduct_price_ot=&price
|
видеорегионалу Gooddock hotmail Google на толстовая комфорталенны Berlingo по
давлений
| 138 | 121
|
| игры для дер блич |
http://kinopoisk.ru/a-albums_scroll_to_auto_id=363064472354&lb_id=1559843
| Легко на купить автозаврам телась
Google Anaissage_599-61 «Оверлок колепный рецепт: Твери
| 114 | 106 |
| винки медведь смотреть объятный ветерин |
http://smeshariki.ru/a-folder-4/#page-3.2.1; WOW64;
Edition=1&input_age17/#page/Jeep,Lexus/rodimomu_vsegoddelki.ru/carbuznyj-90472-0-014031818%26height%3D901634571
| видеорегионалу Google - Доставщиков и
актрическая
| 102 | 85 |
| кино 2009) смотреть онлайн бессмерти мк в россипед |
http://domchelove.ru/#!/search/page
| Далее о коллекции в GIMI LANCIA
0K3Y318104 продать Google, go-go в регистрии — Мой Крым
| 90 | 70 |
| винки медведь смотреть |
http://smeshariki.ru/a-folder-4/#page-3.2.1; WOW64;
Edition=1&input_active/?do=showCampState/renatzija-na-brietielkakh%2F&ti=С
|
видеорегионалу Google - модного языке - Пульс
| 87 | 56
|
| тайны избавитель в владимира для университет масляться |
http://smeshariki.ru/a-folder=cars/article=199980150195,0.107736/detail.aspx#location=search?text=asc&maxyear=2001216629%26sob%3D3159&input_who1=1&cid=577&oki=1&op_product_id=25&pvno=2&evlg=VC,2;VL
| Амитин обувь - Яндекс.Видео+текст песен Google.com
| 64 | 56
|
| коптимиквиды юриста с роуз рая |
https://produkty%2Fpulove.ru/booklyattion-war-sinij-9182/women
| Легко на участные участников., Цены -
Стильная парнем. Саганрог догадения : Турции, купить у 10 дне кольные машинки
не представки - Новая с избиение спродажа: котята 2014 г.в. Цена:
47500-10ECO060 – -------- купить квартиру Оренбург (России Galantrax Flamiliada
Google, Nо 18 фотоконверк Супер Кардиган | 45 | 12 |
| винки медведь смотрейлера начальник |
http://smeshariki.ru/a-folder-4/#page-3.2.1; WOW64; Edition=1&input_active/
| видеорегионалу Google - модных
Челябинск
| 40 | 35 |
+--------------------------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----+-----------------------------+
10 rows in set. Query took 36.094 seconds.
-----------------------------------------
26. SELECT * FROM hits WHERE "URL" LIKE '%google%' ORDER BY "EventTime"
LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.042 seconds.
+---------------------+------------+-------------------------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+-----------+-------------+----------+---------------------+--------------+----+-----------+-----------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-------------------+-----------------+---------------+-------------+-----------------+------------------+-----------------+------------+------------+-------------+----------+----------+----------------+----------------+--------------+------------------+----------+-------------+------------------+--------+-------------+----------------+----------------+----------------------
--------------+-------------+-------------+-------------------+--------------------+----------------+-----------------+---------------------+---------------------+---------------------+---------------------+----------------------+-------------+--------+------------+-------------+---------------------+-------------+------------+--------------+---------+-------------+---------------+----------+----------+----------------+-----+-----+--------+-----------+-----------+-------------+------------+------------+---------------+-----------------+----------------+---------------+--------------+-----------+------------+-----------+---------------+---------------------+-------------------+-------------+-----------------------+------------------+------------+--------------+---------------+-----------------+---------------------+--------------------+--------------+------------------+-----------+-----------+-------------+------------+---------+---------+----------+----------------------+-----------
-----------+------+
| WatchID | JavaEnable | Title
| GoodEvent | EventTime | EventDate | CounterID | ClientIP | RegionID
| UserID | CounterClass | OS | UserAgent | URL
| Referer
| IsRefresh |
RefererCategoryID | RefererRegionID | URLCategoryID | URLRegionID |
ResolutionWidth | ResolutionHeight | ResolutionDepth | FlashMajor | FlashMinor
| FlashMinor2 | NetMajor | NetMinor | UserAgentMajor | UserAgentMinor |
CookieEnable | JavascriptEnable | IsMobile | MobilePhone | MobilePhoneModel |
Params | IPNetworkID | TraficSourceID | SearchEngineID | SearchPhrase
| AdvEngineID | IsArtifical | WindowClientWidth |
WindowClientHeight | ClientTimeZone | ClientEventTime | SilverlightVersion1 |
SilverlightVersion2 | SilverlightVersion3 | SilverlightVersion4 | PageCharset
| CodeVersion | IsLink | IsDownload | IsNotBounce | FUniqID
| OriginalURL | HID | IsOldCounter | IsEvent | IsParameter |
DontCountHits | WithHash | HitColor | LocalEventTime | Age | Sex | Income |
Interests | Robotness | RemoteIP | WindowName | OpenerName | HistoryLength |
BrowserLanguage | BrowserCountry | SocialNetwork | SocialAction | HTTPError |
SendTiming | DNSTiming | ConnectTiming | ResponseStartTiming |
ResponseEndTiming | FetchTiming | SocialSourceNetworkID | SocialSourcePage |
ParamPrice | ParamOrderID | ParamCurrency | ParamCurrencyID |
OpenstatServiceName | OpenstatCampaignID | OpenstatAdID | OpenstatSourceID |
UTMSource | UTMMedium | UTMCampaign | UTMContent | UTMTerm | FromTag | HasGCLID
| RefererHash | URLHash
| CLID |
+---------------------+------------+-------------------------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+-----------+-------------+----------+---------------------+--------------+----+-----------+-----------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-------------------+-----------------+---------------+-------------+-----------------+------------------+-----------------+------------+------------+-------------+----------+----------+----------------+----------------+--------------+------------------+----------+-------------+------------------+--------+-------------+----------------+----------------+----------------------
--------------+-------------+-------------+-------------------+--------------------+----------------+-----------------+---------------------+---------------------+---------------------+---------------------+----------------------+-------------+--------+------------+-------------+---------------------+-------------+------------+--------------+---------+-------------+---------------+----------+----------+----------------+-----+-----+--------+-----------+-----------+-------------+------------+------------+---------------+-----------------+----------------+---------------+--------------+-----------+------------+-----------+---------------+---------------------+-------------------+-------------+-----------------------+------------------+------------+--------------+---------------+-----------------+---------------------+--------------------+--------------+------------------+-----------+-----------+-------------+------------+---------+---------+----------+----------------------+-----------
-----------+------+
| 7675678523794456216 | 1 | Glavnaya gorand. Цветные объявлений
районе, вером
| 1 | 1372708869 | 15888 | 64469 | 1840073959 | 2
| 3714843517822510735 | 0 | 44 | 5 |
http://e96.ru/search/page.googleTBR%26ad%3D0%26rnd%3D158197%26anbietersburg
| http://bdsmpeople.ru/obrazom_position/?page
| 0
| 13593 | 158 | 13606 | 216 | 1638
| 1658 | 22 | 15 | 7 | 700
| 0 | 0 | 22 | nA | 1
| 1 | 0 | 0 | | |
4005373 | -1 | 0
| | 0 | 0 | 1052
| 775 | 135 | 1372760422 | 0
| 0 | 0 | 0 |
windows | 1601 | 0 | 0 | 0 | 0
| | 213893614 | 0 | 0 | 0
| 0 | 0 | 6 | 1372766291 | 0 | 0 | 0 | 0
| 0 | 1412515749 | 63522 | -1 | 12 |
S0 | �
| | | 0 | 0 | 0 | 0
| 445 | 1234 | 0 | 0
| | 0 | | NH | 0
| | | |
| | | | | | | 0
| 5972490271588207794 | 1369713899219085694 | 0 |
| 6147260061318473746 | 1 | Glavnaya gorand. Цветные объявлений
районе, вером
| 1 | 1372708889 | 15888 | 64469 | 1840073959 | 2
| 3714843517822510735 | 0 | 44 | 5 |
http://e96.ru/search/page.googleTBR%26ad%3D0%26rnd%3D158197%26anbietersburg
| http://bdsmpeople.ru/obrazom_position/?page
| 0
| 13593 | 158 | 13606 | 216 | 1638
| 1658 | 22 | 15 | 7 | 700
| 0 | 0 | 22 | D� | 1
| 1 | 0 | 0 | | |
4005373 | -1 | 0
| | 0 | 0 | 1052
| 775 | 135 | 1372760442 | 0
| 0 | 0 | 0 |
windows | 1601 | 0 | 0 | 0 | 0
| | 810892658 | 0 | 0 | 0
| 0 | 0 | 6 | 1372766305 | 0 | 0 | 0 | 0
| 0 | 1412515749 | 63522 | -1 | 13 |
S0 | �
| | | 0 | 0 | 0 | 0
| 0 | 16 | 0 | 0
| | 0 | | NH | 0
| | | |
| | | | | | | 0
| 5972490271588207794 | 1369713899219085694 | 0 |
| 5972689683963797854 | 1 | Glavnaya gorand. Цветные объявлений
районе, вером
| 1 | 1372708931 | 15888 | 64469 | 1840073959 | 2
| 3714843517822510735 | 0 | 44 | 5 |
http://e96.ru/search/page.googleTBR%26ad%3D0%26rnd%3D158197%26anbietersburg
| http://bdsmpeople.ru/obrazom_position/?page
| 0
| 13593 | 158 | 13606 | 216 | 1638
| 1658 | 22 | 15 | 7 | 700
| 0 | 0 | 22 | D� | 1
| 1 | 0 | 0 | | |
4005373 | -1 | 0
| | 0 | 0 | 1052
| 775 | 135 | 1372760476 | 0
| 0 | 0 | 0 |
windows | 1601 | 0 | 0 | 0 | 0
| | 47015096 | 0 | 0 | 0
| 0 | 0 | 6 | 1372766330 | 0 | 0 | 0 | 0
| 0 | 1412515749 | 63522 | -1 | 13 |
S0 | h1 | | | 0 | 0
| 0 | 0 | 0 | 0
| 0 | 0 | | 0 |
| NH | 0 | |
| | | | | |
| | | 0 | 597
2490271588207794 | 1369713899219085694 | 0 |
| 8008688361303225116 | 1 | Скачать онлайн играй! - Туризма -
Крымский тренчкоты в интернет магазин Wildberries.ru (Работа - IRR.ru - модных
словариумных | 1 | 1372709521 | 15888 | 63217 | 1975817788 |
229 | 804133623150786791 | 1 | 44 | 7 |
http://bjdswaps.google-photo
| http://loveche.html?ctid
| 0
| 12409 | 20 | 10093 | 22 | 1749
| 867 | 23 | 15 | 3 |
700.224 | 0 | 0 | 15 | D� | 1
| 1 | 0 | 0 |
| | 3056753 | -1 | 0 |
| 0 | 0 | 1608 | 662
| 135 | 1372745995 | 4 | 1
| 16561 | 0 | windows | 1
| 0 | 0 | 0 | 5347008031302181363 |
| 766531830 | 0 | 0 | 0 | 0 | 0
| 5 | 1372766425 | 31 | 1 | 3 | 11237 | 31 |
1870660671 | -1 | -1 | -1 | E3 | _i
| | | 0 | 0 | 0 |
0 | 0 | 0 | 0 | 0
| | 0 | | NH |
0 | | | |
| | |
| | | | 0 | -2736470446903004689 |
7116991598850737408 | 0 |
| 7436461208655480623 | 1 | Компании Вино в хорошие
| 1 | 1372710744 | 15888 | 35534 | 1741555497 | 39
| 7082047337377160280 | 0 | 44 | 5 |
http://rsdn.ru/catalog/cifrovye-advertisement=little&category=22&input_bdsmpeople.ru/index,google.ru/news/39826
| http://kalina?block/?inst_the_book.php?cPath=40_57470493958402/
| 0 | 10634 | 20
| 0 | 0 | 1996 | 1781
| 37 | 15 | 7 | 700 | 0 | 0
| 22 | D� | 1 | 1 | 0
| 0 | | | 808950 | 5 | 0
|
| 0 | 0 | 1261
| 1017 | 433 | 1372791792 | 4
| 1 | 16561 | 0 |
windows-1251;charset | 1601 | 1 | 0 | 0 |
6804199628189316872 | | 626511463 | 0 | 0 | 0
| 1 | 0 | 5 | 1372732542 | 31 | 2 | 3
| 694 | 57 | 1448806868 | -1 | -1 | -1
| E3 | _i | | | 0
| 0 | 0 | 3 | 345 | 147
| 239 | 0 | | 0 |
| NH | 0 | |
| | | | | |
| | | 0 | 89313463606
92564721 | 1971436513446935197 | 0 |
| 5564518777317455184 | 0 | «set» в пробег аппах и обслуживатизиров
| 1 | 1372711469 | 15888 | 5822 | 1920787234 | 32
| 3712346975274085073 | 1 | 2 | 3 |
http://auto_gruppy/christikha/hotel=-1&trafkey=605&from=&power_name=Платья&produkty%2Furl.google.ru/index
|
http://rmnt.ru/cars/passenger/hellardous/42/~37/?suggest&id=3869551753&custom=0&undefined/undefined/under=28036,5;362;108;16762643539
| 0 |
8563 | 21482 | 9822 | 18528 | 1638
| 1658 | 23 | 15 | 7 | 700
| 0 | 0 | 16 | D� | 1 | 1
| 0 | 0 | | | 207348 |
-1 |
0 | | 0 | 0
| 1509 | 733 | 135 | 1372750392 |
4 | 1 | 15738 | 0
| windows-1251;charset | 1 | 0 | 0 | 0
| 8007561756096276896 | | 1034507462 | 0 | 0 | 0
| 0 | 0 | 5 | 1372759436 | 0 | 0 | 0
| 0 | 0 | 2016848722 | -1 | -1 | -1
| S0 | h1 | | | 0
| 0 | 0 | 0 | 0 | 0
| 0 | 0 | | 0 |
| NH | 0 | |
| | | | |
| | | | 0
| 7820066807630413322 | -3258566084785303139 | 0 |
| 7381524648140977766 | 1 | Ploshchad' stolitsi zwy 110911923, Г
официальная Прессы и Огонек
| 1 | 1372712506 | 15888 | 63217 | 1638850281 | 59
| 1564939829982760596 | 1 | 44 | 5 |
http://bjdleaksbrand=bpc
bonprix%2F12.02&he=1024&location=pm;f=inbox;pmsg_1733/page.google
| http://loveplanet.ru/url?sa=t&rct
| 0 | 12409
| 20 | 10093 | 22 | 1996 | 1666
| 37 | 15 | 7 | 700 | 0 | 0
| 22 | D� | 1 | 1 | 0
| 0 | | | 2059788 | -1 |
0
| | 0 | 0 | 1261
| 1206 | 433 | 1372759478 | 0
| 0 | 0 | 0 |
windows | 1 | 0 | 0 | 0 | 0
| | 827020970 | 0 | 0 | 0
| 0 | 0 | 5 | 1372791236 | 0 | 0 | 0 | 0
| 0 | 2001459352 | -1 | -1 | -1 |
S0 | �
| | | 0 | 0 | 0 | 0
| 0 | 0 | 0 | 0
| | 0 | | NH | 0
| | | |
| | | | | | | 0
| 1384301141639030267 | 9047048983006699504 | 0 |
| 8614832219462424183 | 1 | Модель для сумки - регеш (Россия)
| 1 | 1372713563 | 15888 | 3035 | 2022088895 | 38
| 2590751384199385434 | 1 | 2 | 88 |
http://smeshariki.ru/googleTBR%26ar_ntype=citykurortmag
|
http://holodilnik.ru/GameMain.aspx?color=0&choos&source=web&cd
| 0 | 10271 | 158
| 13384 | 216 | 1917 | 879 |
37 | 15 | 7 | 700 | 0 | 0 |
1 | D� | 1 | 1 | 0 |
0 | | | 3991944 | -1 | 0
| | 0 | 0 | 746
| 464 | 322 | 1372754670 | 0
| 0 | 0 | 0 |
windows-1251;charset | 1 | 0 | 0 | 0 |
7607749204513951316 | | 427646581 | 0 | 0 | 0
| 0 | 0 | 5 | 1372720757 | 50 | 2 | 3
| 0 | 30 | 1146019198 | -1 | -1 | -1
| S0 | �
| | | 0 | 0 | 0 | 0
| 0 | 0 | 0 | 0
| | 0 | | NH | 0
| | | |
| | | | | | | 0
| 1157471009075867478 | 1000799766482180932 | 0 |
| 7168314068394418899 | 1 | по полиция +опытовой рецензии,
| 1 | 1372713760 | 15888 | 35534 | -1420082055 | 11579
| 4822773326251181180 | 0 | 2 | 7 |
http:%2F%2Fsapozhki-advertime-2/#page.google/dodge
| http://saint-peters-total=меньше
100007&text=b.akhua_deckaya-look/time-2/#page=3&oprnd=6817922197946&ei=JtHTUYWRCqXA&bvm=bv.49784469,d.ZWU&cad=rjt&fu=0&type_id=172&msid=1&marka=88&text=krasnaia-moda
| 0 | 14550 | 952 | 8565 | 375
| 1304 | 978 | 37 | 15 | 4
| 700.224 | 2 | 7 | 13 | D� | 1
| 1 | 0 | 0 | |
| 2675432 | 3 | 3
| dave kino 2013 года в ростопримеча | 0 | 0 |
1972 | 778 | 135 | 1372712707 | 4
| 1 | 16561 | 0
| windows | 1601 | 0 | 0 | 0 |
6494516778257365839 | | 393719418 | 0 | 0 | 0
| 0 | 0 | 5 | 1372782490 | 31 | 2 | 2
| 14851 | 1 | -1016483843 | 61823 | -1 | 1
| S0 | �
| | | 0 | 0 | 0 | 0
| 0 | 0 | 0 | 0
| | 0 | | NH | 0
| | | |
| | | | | | | 0
| -4470345086215748575 | -5322637665780806659 | 0 |
| 8235569889353442646 | 1 |
| 1 | 1372713773 | 15888 | 35534 | -1420082055 | 11579
| 4822773326251181180 | 0 | 2 | 7 |
http:%2F%2Fsapozhki-advertime-2/#page.google/dodge
|
| 0
| 0 | 0 | 8565 | 375 | 1304
| 978 | 37 | 15 | 4 |
700.224 | 2 | 7 | 13 | D� | 1
| 1 | 0 | 0 | | |
2675432 | 0 | 0 |
| 0 | 1 | 1972 | 778
| 135 | 1372712722 | 4 | 1
| 16561 | 0 | windows | 1601
| 0 | 0 | 1 | 6494516778257365839 | |
393719418 | 0 | 0 | 0 | 1 | 0 |
5 | 1372782504 | 31 | 2 | 2 | 14851 | 1 |
-1016483843 | 61823 | -1 | 2 | S0 | �
| | | 0 | 318 | 0 | 0
| 0 | 0 | 0 | 0
| | 0 | | NH | 0
| | | |
| | | | | | | 0
| -296158784638538920 | -5322637665780806659 | 0 |
+---------------------+------------+-------------------------------------------------------------------------------------------------------------------------------+-----------+------------+-----------+-----------+-------------+----------+---------------------+--------------+----+-----------+-----------------------------------------------------------------------------------------------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+-------------------+-----------------+---------------+-------------+-----------------+------------------+-----------------+------------+------------+-------------+----------+----------+----------------+----------------+--------------+------------------+----------+-------------+------------------+--------+-------------+----------------+----------------+----------------------
--------------+-------------+-------------+-------------------+--------------------+----------------+-----------------+---------------------+---------------------+---------------------+---------------------+----------------------+-------------+--------+------------+-------------+---------------------+-------------+------------+--------------+---------+-------------+---------------+----------+----------+----------------+-----+-----+--------+-----------+-----------+-------------+------------+------------+---------------+-----------------+----------------+---------------+--------------+-----------+------------+-----------+---------------+---------------------+-------------------+-------------+-----------------------+------------------+------------+--------------+---------------+-----------------+---------------------+--------------------+--------------+------------------+-----------+-----------+-------------+------------+---------+---------+----------+----------------------+-----------
-----------+------+
10 rows in set. Query took 92.880 seconds.
-----------------------------------------
27. SELECT "SearchPhrase" FROM hits WHERE "SearchPhrase" <> '' ORDER BY
"EventTime" LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.045 seconds.
+------------------------------------+
| SearchPhrase |
+------------------------------------+
| galaxy s4 zoom фильм |
| фильм небольшой бизнеса североятно |
| ночно китая женщины |
| симптомы регистратов |
| компьютерапии серия нарий |
| расписание мультиварка для |
| отдыха чем прокат |
| брита ганам котлы на шерлок |
| скачать читалию в духовке |
| анапа оперевянные волшебную |
+------------------------------------+
10 rows in set. Query took 5.124 seconds.
-----------------------------------------
28. SELECT "SearchPhrase" FROM hits WHERE "SearchPhrase" <> '' ORDER BY
"SearchPhrase" LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.048 seconds.
+-----------------------------------------+
| SearchPhrase |
+-----------------------------------------+
| береж |
| за русский стил видео какой |
| завод тандалищные прода |
| заочное по земли в обрезни и метро |
| заочное сад цены нарощения музыка визу |
| зве |
| земные огурцы раб |
| золотой сайт samsung |
| прав |
| светы женске 2 сезон |
+-----------------------------------------+
10 rows in set. Query took 11.645 seconds.
-----------------------------------------
29. SELECT "SearchPhrase" FROM hits WHERE "SearchPhrase" <> '' ORDER BY
"EventTime", "SearchPhrase" LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.048 seconds.
+------------------------------------+
| SearchPhrase |
+------------------------------------+
| galaxy s4 zoom фильм |
| ночно китая женщины |
| симптомы регистратов |
| фильм небольшой бизнеса североятно |
| авом констеть ребенка краево |
| анапа оперевянные волшебную |
| брита ганам котлы на шерлок |
| компьютерапии серия нарий |
| отдыха чем прокат |
| расписание мультиварка для |
+------------------------------------+
10 rows in set. Query took 9.515 seconds.
-----------------------------------------
30. SELECT "CounterID", AVG(length("URL")) AS l, COUNT(*) AS c FROM hits
WHERE "URL" <> '' GROUP BY "CounterID" HAVING COUNT(*) > 100000 ORDER BY l DESC
LIMIT 25;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.047 seconds.
+-----------+--------------------+---------+
| CounterID | l | c |
+-----------+--------------------+---------+
| 233773 | 453.1621381043362 | 2938865 |
| 245438 | 261.5559560703286 | 2510103 |
| 122612 | 230.6844119219688 | 3574007 |
| 234004 | 198.08934467443225 | 238660 |
| 1634 | 187.95619823716314 | 323229 |
| 786 | 180.36009060135405 | 120528 |
| 114157 | 139.11817030793685 | 216408 |
| 515 | 123.96619630106122 | 146907 |
| 256004 | 121.86098341705791 | 858171 |
| 95427 | 116.91913835204352 | 374306 |
| 199550 | 106.89178533979685 | 7115413 |
| 220992 | 103.75863804906453 | 494614 |
| 196239 | 95.01398682515553 | 163797 |
| 96948 | 92.1134607276574 | 396093 |
| 62 | 91.94268102689155 | 738150 |
| 188878 | 90.26380938339348 | 311998 |
| 249603 | 90.00927488053189 | 120325 |
| 3922 | 85.88639543083326 | 8527069 |
| 191697 | 85.03551145479048 | 124664 |
| 97467 | 82.76263550290444 | 131178 |
| 186300 | 82.05936495792844 | 802561 |
| 230962 | 74.73222907051642 | 169223 |
| 77639 | 74.65631730856313 | 253961 |
| 146891 | 74.13011535042938 | 605286 |
| 38 | 73.96797565827048 | 507770 |
+-----------+--------------------+---------+
25 rows in set. Query took 21.719 seconds.
-----------------------------------------
31. SELECT REGEXP_REPLACE("Referer", '^https?://(?:www.)?([^/]+)/.*$', '1')
AS k, AVG(length("Referer")) AS l, COUNT(*) AS c, MIN("Referer") FROM hits
WHERE "Referer" <> '' GROUP BY k HAVING COUNT(*) > 100000 ORDER BY l DESC LIMIT
25;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.079 seconds.
+-----------------------------------------------------------------------+-------------------+----------+-----------------------------------------------------------------------------------------------+
| k | l
| c | MIN(hits.Referer)
|
+-----------------------------------------------------------------------+-------------------+----------+-----------------------------------------------------------------------------------------------+
| 1 |
81.60577248233396 | 66284655 |
http://%26ad%3D1%25EA%25D0%26utm_source=web&cd=19590&input_onlist/би-2 место
будущей кондицин |
| http:%2F%2Fwwww.regnancies/search&evL8gE&where=all&filmId=bEmYZc_WTDE | 69
| 207347 |
http:%2F%2Fwwww.regnancies/search&evL8gE&where=all&filmId=bEmYZc_WTDE
|
| http://loveche.html?ctid | 24
| 144901 | http://loveche.html?ctid
|
| http://rukodeliveresult | 23
| 226135 | http://rukodeliveresult
|
| http://smeshariki.ru | 20
| 210736 | http://smeshariki.ru
|
| http:%2F%2Fviewtopic | 20
| 391115 | http:%2F%2Fviewtopic
|
| http://holodilnik.ru | 20
| 133893 | http://holodilnik.ru
|
| http:%2F%2FviewType | 19
| 148907 | http:%2F%2FviewType
|
| http:%2F%2Fwwww.ukr | 19
| 655178 | http:%2F%2Fwwww.ukr
|
| http://новострашная | 19
| 731499 | http://новострашная
|
| http://state=2008 | 17
| 139630 | http://state=2008
|
+-----------------------------------------------------------------------+-------------------+----------+-----------------------------------------------------------------------------------------------+
11 rows in set. Query took 691.504 seconds.
-----------------------------------------
32. SELECT SUM("ResolutionWidth"), SUM("ResolutionWidth" + 1),
SUM("ResolutionWidth" + 2), SUM("ResolutionWidth" + 3), SUM("ResolutionWidth" +
4), SUM("ResolutionWidth" + 5), SUM("ResolutionWidth" + 6),
SUM("ResolutionWidth" + 7), SUM("ResolutionWidth" + 8), SUM("ResolutionWidth" +
9), SUM("ResolutionWidth" + 10), SUM("ResolutionWidth" + 11),
SUM("ResolutionWidth" + 12), SUM("ResolutionWidth" + 13), SUM("ResolutionWidth"
+ 14), SUM("ResolutionWidth" + 15), SUM("ResolutionWidth" + 16),
SUM("ResolutionWidth" + 17), SUM("ResolutionWidth" + 18), SUM("ResolutionWidth"
+ 19), SUM("ResolutionWidth" + 20), SUM("ResolutionWidth" + 21),
SUM("ResolutionWidth" + 22), SUM("ResolutionWidth" + 23), SUM("ResolutionWidth"
+ 24), SUM("ResolutionWidth" + 25), SUM("ResolutionWidth" + 26),
SUM("ResolutionWidth" + 27), SUM("ResolutionWidth" + 28), SUM("ResolutionWidth"
+ 29), SUM("ResolutionWidth" + 30), SUM("ResolutionWidth" + 31),
SUM("ResolutionWidth" + 32), SUM("ResolutionWidth" + 33), SUM("Resolut
ionWidth" + 34), SUM("ResolutionWidth" + 35), SUM("ResolutionWidth" + 36),
SUM("ResolutionWidth" + 37), SUM("ResolutionWidth" + 38), SUM("ResolutionWidth"
+ 39), SUM("ResolutionWidth" + 40), SUM("ResolutionWidth" + 41),
SUM("ResolutionWidth" + 42), SUM("ResolutionWidth" + 43), SUM("ResolutionWidth"
+ 44), SUM("ResolutionWidth" + 45), SUM("ResolutionWidth" + 46),
SUM("ResolutionWidth" + 47), SUM("ResolutionWidth" + 48), SUM("ResolutionWidth"
+ 49), SUM("ResolutionWidth" + 50), SUM("ResolutionWidth" + 51),
SUM("ResolutionWidth" + 52), SUM("ResolutionWidth" + 53), SUM("ResolutionWidth"
+ 54), SUM("ResolutionWidth" + 55), SUM("ResolutionWidth" + 56),
SUM("ResolutionWidth" + 57), SUM("ResolutionWidth" + 58), SUM("ResolutionWidth"
+ 59), SUM("ResolutionWidth" + 60), SUM("ResolutionWidth" + 61),
SUM("ResolutionWidth" + 62), SUM("ResolutionWidth" + 63), SUM("ResolutionWidth"
+ 64), SUM("ResolutionWidth" + 65), SUM("ResolutionWidth" + 66),
SUM("ResolutionWidth" + 67), SUM("ResolutionWidth" +
68), SUM("ResolutionWidth" + 69), SUM("ResolutionWidth" + 70),
SUM("ResolutionWidth" + 71), SUM("ResolutionWidth" + 72), SUM("ResolutionWidth"
+ 73), SUM("ResolutionWidth" + 74), SUM("ResolutionWidth" + 75),
SUM("ResolutionWidth" + 76), SUM("ResolutionWidth" + 77), SUM("ResolutionWidth"
+ 78), SUM("ResolutionWidth" + 79), SUM("ResolutionWidth" + 80),
SUM("ResolutionWidth" + 81), SUM("ResolutionWidth" + 82), SUM("ResolutionWidth"
+ 83), SUM("ResolutionWidth" + 84), SUM("ResolutionWidth" + 85),
SUM("ResolutionWidth" + 86), SUM("ResolutionWidth" + 87), SUM("ResolutionWidth"
+ 88), SUM("ResolutionWidth" + 89) FROM hits;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.098 seconds.
+---------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+-----------------------------
-------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+-------------------------------------
-----+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+--
----------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+
| SUM(hits.ResolutionWidth) | SUM(hits.ResolutionWidth Plus Int64(1)) |
SUM(hits.ResolutionWidth Plus Int64(2)) | SUM(hits.ResolutionWidth Plus
Int64(3)) | SUM(hits.ResolutionWidth Plus Int64(4)) | SUM(hits.ResolutionWidth
Plus Int64(5)) | SUM(hits.ResolutionWidth Plus Int64(6)) |
SUM(hits.ResolutionWidth Plus Int64(7)) | SUM(hits.ResolutionWidth Plus
Int64(8)) | SUM(hits.ResolutionWidth Plus Int64(9)) | SUM(hits.ResolutionWidth
Plus Int64(10)) | SUM(hits.ResolutionWidth Plus Int64(11)) |
SUM(hits.ResolutionWidth Plus Int64(12)) | SUM(hits.ResolutionWidth Plus
Int64(13)) | SUM(hits.ResolutionWidth Plus Int64(14)) |
SUM(hits.ResolutionWidth Plus Int64(15)) | SUM(hits.ResolutionWidth Plus
Int64(16)) | SUM(hits.ResolutionWidth Plus Int64(17)) |
SUM(hits.ResolutionWidth Plus Int64(18)) | SUM(hits.ResolutionWidth Plus
Int64(19)) | SUM(hits.ResolutionWidth Plus Int64(20)) |
SUM(hits.ResolutionWidth Plus Int64(21)) | SUM(hits.ResolutionWidth Plus
Int64(22)) | SUM(hits.ResolutionWidth Plu
s Int64(23)) | SUM(hits.ResolutionWidth Plus Int64(24)) |
SUM(hits.ResolutionWidth Plus Int64(25)) | SUM(hits.ResolutionWidth Plus
Int64(26)) | SUM(hits.ResolutionWidth Plus Int64(27)) |
SUM(hits.ResolutionWidth Plus Int64(28)) | SUM(hits.ResolutionWidth Plus
Int64(29)) | SUM(hits.ResolutionWidth Plus Int64(30)) |
SUM(hits.ResolutionWidth Plus Int64(31)) | SUM(hits.ResolutionWidth Plus
Int64(32)) | SUM(hits.ResolutionWidth Plus Int64(33)) |
SUM(hits.ResolutionWidth Plus Int64(34)) | SUM(hits.ResolutionWidth Plus
Int64(35)) | SUM(hits.ResolutionWidth Plus Int64(36)) |
SUM(hits.ResolutionWidth Plus Int64(37)) | SUM(hits.ResolutionWidth Plus
Int64(38)) | SUM(hits.ResolutionWidth Plus Int64(39)) |
SUM(hits.ResolutionWidth Plus Int64(40)) | SUM(hits.ResolutionWidth Plus
Int64(41)) | SUM(hits.ResolutionWidth Plus Int64(42)) |
SUM(hits.ResolutionWidth Plus Int64(43)) | SUM(hits.ResolutionWidth Plus
Int64(44)) | SUM(hits.ResolutionWidth Plus Int64(45)) |
SUM(hits.ResolutionWidth Plus Int64(
46)) | SUM(hits.ResolutionWidth Plus Int64(47)) | SUM(hits.ResolutionWidth
Plus Int64(48)) | SUM(hits.ResolutionWidth Plus Int64(49)) |
SUM(hits.ResolutionWidth Plus Int64(50)) | SUM(hits.ResolutionWidth Plus
Int64(51)) | SUM(hits.ResolutionWidth Plus Int64(52)) |
SUM(hits.ResolutionWidth Plus Int64(53)) | SUM(hits.ResolutionWidth Plus
Int64(54)) | SUM(hits.ResolutionWidth Plus Int64(55)) |
SUM(hits.ResolutionWidth Plus Int64(56)) | SUM(hits.ResolutionWidth Plus
Int64(57)) | SUM(hits.ResolutionWidth Plus Int64(58)) |
SUM(hits.ResolutionWidth Plus Int64(59)) | SUM(hits.ResolutionWidth Plus
Int64(60)) | SUM(hits.ResolutionWidth Plus Int64(61)) |
SUM(hits.ResolutionWidth Plus Int64(62)) | SUM(hits.ResolutionWidth Plus
Int64(63)) | SUM(hits.ResolutionWidth Plus Int64(64)) |
SUM(hits.ResolutionWidth Plus Int64(65)) | SUM(hits.ResolutionWidth Plus
Int64(66)) | SUM(hits.ResolutionWidth Plus Int64(67)) |
SUM(hits.ResolutionWidth Plus Int64(68)) | SUM(hits.ResolutionWidth Plus
Int64(69)) | S
UM(hits.ResolutionWidth Plus Int64(70)) | SUM(hits.ResolutionWidth Plus
Int64(71)) | SUM(hits.ResolutionWidth Plus Int64(72)) |
SUM(hits.ResolutionWidth Plus Int64(73)) | SUM(hits.ResolutionWidth Plus
Int64(74)) | SUM(hits.ResolutionWidth Plus Int64(75)) |
SUM(hits.ResolutionWidth Plus Int64(76)) | SUM(hits.ResolutionWidth Plus
Int64(77)) | SUM(hits.ResolutionWidth Plus Int64(78)) |
SUM(hits.ResolutionWidth Plus Int64(79)) | SUM(hits.ResolutionWidth Plus
Int64(80)) | SUM(hits.ResolutionWidth Plus Int64(81)) |
SUM(hits.ResolutionWidth Plus Int64(82)) | SUM(hits.ResolutionWidth Plus
Int64(83)) | SUM(hits.ResolutionWidth Plus Int64(84)) |
SUM(hits.ResolutionWidth Plus Int64(85)) | SUM(hits.ResolutionWidth Plus
Int64(86)) | SUM(hits.ResolutionWidth Plus Int64(87)) |
SUM(hits.ResolutionWidth Plus Int64(88)) | SUM(hits.ResolutionWidth Plus
Int64(89)) |
+---------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+-----------------------------
-------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+-------------------------------------
-----+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+--
----------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+
| 151345005230 | 151445002727 |
151545000224 | 151644997721
| 151744995218 | 151844992715
| 151944990212 | 152044987709
| 152144985206 | 152244982703
| 152344980200 | 152444977697
| 152544975194 | 152644972691
| 152744970188 |
152844967685 | 152944965182
| 153044962679 | 153144960176
| 153244957673 | 153344955170
| 153444952667 | 153544950164
| 153644947661
| 153744945158 | 153844942655
| 153944940152 | 154044937649
| 154144935146 |
154244932643 | 154344930140
| 154444927637 | 154544925134
| 154644922631 | 154744920128
| 154844917625 | 154944915122
| 155044912619 | 155144910116
| 155244907613 |
155344905110 | 155444902607
| 155544900104 | 155644897601
| 155744895098 | 155844892595
| 155944890092
| 156044887589 | 156144885086
| 156244882583 | 156344880080
| 156444877577 | 156544875074
| 156644872571 |
156744870068 | 156844867565
| 156944865062 | 157044862559
| 157144860056 | 157244857553
| 157344855050 | 157444852547
| 157544850044 | 157644847541
| 157744845038 |
157844842535 | 157944840032
| 158044837529 | 158144835026
| 158244832523 | 1
58344830020 | 158444827517
| 158544825014 | 158644822511
| 158744820008 | 158844817505
| 158944815002 | 159044812499
| 159144809996 | 159244807493
| 159344804990 |
159444802487 | 159544799984
| 159644797481 | 159744794978
| 159844792475 | 159944789972
| 160044787469 | 160144784966
| 160244782463 |
+---------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+-----------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+-----------------------------
-------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+-------------------------------------
-----+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+--
----------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+------------------------------------------+
1 row in set. Query took 6.763 seconds.
-----------------------------------------
33. SELECT "SearchEngineID", "ClientIP", COUNT(*) AS c, SUM("IsRefresh"),
AVG("ResolutionWidth") FROM hits WHERE "SearchPhrase" <> '' GROUP BY
"SearchEngineID", "ClientIP" ORDER BY c DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.100 seconds.
+----------------+-------------+------+---------------------+---------------------------+
| SearchEngineID | ClientIP | c | SUM(hits.IsRefresh) |
AVG(hits.ResolutionWidth) |
+----------------+-------------+------+---------------------+---------------------------+
| 2 | 1138507705 | 1633 | 35 |
1408.0122473974282 |
| 2 | 1740861572 | 1331 | 28 |
1577.945905334335 |
| 2 | -807147100 | 1144 | 35 |
1553.1984265734266 |
| 2 | -497906719 | 1140 | 36 |
1543.4140350877192 |
| 2 | -1945757555 | 1105 | 30 |
1557.387330316742 |
| 2 | -1870623097 | 1102 | 31 |
1555.6588021778584 |
| 2 | -631062503 | 1083 | 31 |
1581.8171745152354 |
| 2 | -465813166 | 1082 | 30 |
1541.253234750462 |
| 2 | -1743596151 | 1080 | 24 |
1559.8092592592593 |
| 2 | -265917476 | 1058 | 32 |
1556.2003780718337 |
+----------------+-------------+------+---------------------+---------------------------+
10 rows in set. Query took 14.410 seconds.
-----------------------------------------
34. SELECT "WatchID", "ClientIP", COUNT(*) AS c, SUM("IsRefresh"),
AVG("ResolutionWidth") FROM hits WHERE "SearchPhrase" <> '' GROUP BY "WatchID",
"ClientIP" ORDER BY c DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.088 seconds.
+---------------------+-------------+---+---------------------+---------------------------+
| WatchID | ClientIP | c | SUM(hits.IsRefresh) |
AVG(hits.ResolutionWidth) |
+---------------------+-------------+---+---------------------+---------------------------+
| 7656880916702716971 | 1563334575 | 1 | 0 | 1638
|
| 4651420832394813828 | -640509850 | 1 | 1 | 1917
|
| 5329048601275700411 | -1822784750 | 1 | 0 | 1368
|
| 6334984420893924961 | -334172838 | 1 | 0 | 1917
|
| 7019588414274311318 | -342684037 | 1 | 0 | 1996
|
| 6036390907559303203 | -404428074 | 1 | 0 | 2038
|
| 8417313803643791879 | -404428074 | 1 | 1 | 2038
|
| 6992937563892450735 | 1189777942 | 1 | 0 | 1750
|
| 6830759596827044062 | 1697719952 | 1 | 1 | 1996
|
| 6026588014492109349 | -1670347758 | 1 | 0 | 1990
|
+---------------------+-------------+---+---------------------+---------------------------+
10 rows in set. Query took 15.102 seconds.
-----------------------------------------
35. SELECT "WatchID", "ClientIP", COUNT(*) AS c, SUM("IsRefresh"),
AVG("ResolutionWidth") FROM hits GROUP BY "WatchID", "ClientIP" ORDER BY c DESC
LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.078 seconds.
+---------------------+-------------+---+---------------------+---------------------------+
| WatchID | ClientIP | c | SUM(hits.IsRefresh) |
AVG(hits.ResolutionWidth) |
+---------------------+-------------+---+---------------------+---------------------------+
| 6655575552203051303 | 1611957945 | 2 | 0 | 1638
|
| 8566928176839891583 | -1402644643 | 2 | 0 | 1368
|
| 7904046282518428963 | 1509330109 | 2 | 0 | 1368
|
| 7224410078130478461 | -776509581 | 2 | 0 | 1368
|
| 8127510852740380089 | 1405793066 | 1 | 0 | 1750
|
| 8057970264774035478 | 2052396662 | 1 | 1 | 1250
|
| 9058420313745027552 | 1390616831 | 1 | 1 | 1638
|
| 4731543847644847438 | 1527050675 | 1 | 1 | 1638
|
| 9000702764796716180 | -801175448 | 1 | 1 | 1638
|
| 4959481833316493811 | -801175448 | 1 | 0 | 1638
|
+---------------------+-------------+---+---------------------+---------------------------+
10 rows in set. Query took 96.169 seconds.
-----------------------------------------
36. SELECT "URL", COUNT(*) AS c FROM hits GROUP BY "URL" ORDER BY c DESC
LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.090 seconds.
+-------------------------------------------------------+---------+
| URL | c |
+-------------------------------------------------------+---------+
| http://liver.ru/belgorod/page/1006.jки/доп_приборы | 3288173 |
| http://kinopoisk.ru | 1625250 |
| http://bdsm_po_yers=0&with_video | 791465 |
| http://video.yandex | 582400 |
| http://smeshariki.ru/region | 514984 |
| http://auto_fiat_dlya-bluzki%2F8536.30.18&he=900&with | 507995 |
| http://liver.ru/place_rukodel=365115eb7bbb90 | 359893 |
| http://kinopoisk.ru/vladimir.irr.ru | 354690 |
| http://video.yandex.ru/search/?jenre=50&s_yers | 318979 |
| http://tienskaia-moda | 289355 |
+-------------------------------------------------------+---------+
10 rows in set. Query took 36.146 seconds.
-----------------------------------------
37. SELECT 1, "URL", COUNT(*) AS c FROM hits GROUP BY 1, "URL" ORDER BY c
DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.066 seconds.
+----------+-------------------------------------------------------+---------+
| Int64(1) | URL | c
|
+----------+-------------------------------------------------------+---------+
| 1 | http://liver.ru/belgorod/page/1006.jки/доп_приборы | 3288173
|
| 1 | http://kinopoisk.ru | 1625250
|
| 1 | http://bdsm_po_yers=0&with_video | 791465
|
| 1 | http://video.yandex | 582400
|
| 1 | http://smeshariki.ru/region | 514984
|
| 1 | http://auto_fiat_dlya-bluzki%2F8536.30.18&he=900&with | 507995
|
| 1 | http://liver.ru/place_rukodel=365115eb7bbb90 | 359893
|
| 1 | http://kinopoisk.ru/vladimir.irr.ru | 354690
|
| 1 | http://video.yandex.ru/search/?jenre=50&s_yers | 318979
|
| 1 | http://tienskaia-moda | 289355
|
+----------+-------------------------------------------------------+---------+
10 rows in set. Query took 32.543 seconds.
-----------------------------------------
38. SELECT "ClientIP", "ClientIP" - 1, "ClientIP" - 2, "ClientIP" - 3,
COUNT(*) AS c FROM hits GROUP BY "ClientIP", "ClientIP" - 1, "ClientIP" - 2,
"ClientIP" - 3 ORDER BY c DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.061 seconds.
+-------------+------------------------------+------------------------------+------------------------------+-------+
| ClientIP | hits.ClientIP Minus Int64(1) | hits.ClientIP Minus Int64(2)
| hits.ClientIP Minus Int64(3) | c |
+-------------+------------------------------+------------------------------+------------------------------+-------+
| -39921974 | -39921975 | -39921976
| -39921977 | 47008 |
| -1698104457 | -1698104458 | -1698104459
| -1698104460 | 29121 |
| -1175819552 | -1175819553 | -1175819554
| -1175819555 | 25333 |
| 1696638182 | 1696638181 | 1696638180
| 1696638179 | 20220 |
| 1138507705 | 1138507704 | 1138507703
| 1138507702 | 15778 |
| -927025522 | -927025523 | -927025524
| -927025525 | 12768 |
| -1262139876 | -1262139877 | -1262139878
| -1262139879 | 11348 |
| 1740861572 | 1740861571 | 1740861570
| 1740861569 | 11314 |
| -807147100 | -807147101 | -807147102
| -807147103 | 9880 |
| -631062503 | -631062504 | -631062505
| -631062506 | 9718 |
+-------------+------------------------------+------------------------------+------------------------------+-------+
10 rows in set. Query took 7.013 seconds.
-----------------------------------------
39. SELECT "URL", COUNT(*) AS PageViews FROM hits WHERE "CounterID" = 62 AND
"EventDate" >= '2013-07-01' AND "EventDate" <= '2013-07-31' AND "DontCountHits"
= 0 AND "IsRefresh" = 0 AND "URL" <> '' GROUP BY "URL" ORDER BY PageViews DESC
LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.066 seconds.
0 rows in set. Query took 0.079 seconds.
-----------------------------------------
40. SELECT "Title", COUNT(*) AS PageViews FROM hits WHERE "CounterID" = 62
AND "EventDate" >= '2013-07-01' AND "EventDate" <= '2013-07-31' AND
"DontCountHits" = 0 AND "IsRefresh" = 0 AND "Title" <> '' GROUP BY "Title"
ORDER BY PageViews DESC LIMIT 10;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.066 seconds.
0 rows in set. Query took 0.073 seconds.
-----------------------------------------
41. SELECT "URL", COUNT(*) AS PageViews FROM hits WHERE "CounterID" = 62 AND
"EventDate" >= '2013-07-01' AND "EventDate" <= '2013-07-31' AND "IsRefresh" = 0
AND "IsLink" <> 0 AND "IsDownload" = 0 GROUP BY "URL" ORDER BY PageViews DESC
LIMIT 10 OFFSET 1000;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.066 seconds.
0 rows in set. Query took 0.074 seconds.
-----------------------------------------
42. SELECT "TraficSourceID", "SearchEngineID", "AdvEngineID", CASE WHEN
("SearchEngineID" = 0 AND "AdvEngineID" = 0) THEN "Referer" ELSE '' END AS Src,
"URL" AS Dst, COUNT(*) AS PageViews FROM hits WHERE "CounterID" = 62 AND
"EventDate" >= '2013-07-01' AND "EventDate" <= '2013-07-31' AND "IsRefresh" = 0
GROUP BY "TraficSourceID", "SearchEngineID", "AdvEngineID", Src, Dst ORDER BY
PageViews DESC LIMIT 10 OFFSET 1000;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.066 seconds.
0 rows in set. Query took 0.082 seconds.
-----------------------------------------
43. SELECT "URLHash", "EventDate", COUNT(*) AS PageViews FROM hits WHERE
"CounterID" = 62 AND "EventDate" >= '2013-07-01' AND "EventDate" <=
'2013-07-31' AND "IsRefresh" = 0 AND "TraficSourceID" IN (-1, 6) AND
"RefererHash" = 3594120000172545465 GROUP BY "URLHash", "EventDate" ORDER BY
PageViews DESC LIMIT 10 OFFSET 100;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.066 seconds.
0 rows in set. Query took 0.079 seconds.
-----------------------------------------
44. SELECT "WindowClientWidth", "WindowClientHeight", COUNT(*) AS PageViews
FROM hits WHERE "CounterID" = 62 AND "EventDate" >= '2013-07-01' AND
"EventDate" <= '2013-07-31' AND "IsRefresh" = 0 AND "DontCountHits" = 0 AND
"URLHash" = 2868770270353813622 GROUP BY "WindowClientWidth",
"WindowClientHeight" ORDER BY PageViews DESC LIMIT 10 OFFSET 10000;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.066 seconds.
0 rows in set. Query took 0.075 seconds.
-----------------------------------------
45. SELECT DATE_TRUNC('minute', "EventTime") AS M, COUNT(*) AS PageViews
FROM hits WHERE "CounterID" = 62 AND "EventDate" >= '2013-07-14' AND
"EventDate" <= '2013-07-15' AND "IsRefresh" = 0 AND "DontCountHits" = 0 GROUP
BY DATE_TRUNC('minute', "EventTime") ORDER BY DATE_TRUNC('minute', "EventTime")
LIMIT 10 OFFSET 1000;
-----------------------------------------
DataFusion CLI v10.0.0
0 rows in set. Query took 0.066 seconds.
Plan("Coercion from [Utf8, Int64] to the signature Exact([Utf8,
Timestamp(Nanosecond, None)]) failed.")
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
