waitingkuo commented on issue #2902: URL: https://github.com/apache/arrow-datafusion/issues/2902#issuecomment-1203256346
@andygrove I created the datafusion branch and submitted a [daft pull request](https://github.com/ClickHouse/ClickBench/pull/14) my branch is here https://github.com/waitingkuo/ClickBench/tree/datafusion/datafusion <br/> The original create.sql is (https://github.com/waitingkuo/ClickBench/blob/datafusion/clickhouse/queries.sql) e.g. ```SELECT COUNT(*) FROM hits WHERE AdvEngineID <> 0;``` Since datafusion doesn't support uppercase column name without double quotes ("), so i modify them as (https://github.com/waitingkuo/ClickBench/blob/datafusion/datafusion/queries.sql) e.g. ```SELECT COUNT(*) FROM hits WHERE "AdvEngineID" <> 0;``` <br/> we failed 17 queries out of 43. here the full result (i tested in my mac, not yet find a chance to use a high end linux vm to test it) i'm using my mac to run the test, you could reproduce by ```run2.sh```, please follow the [readme](https://github.com/waitingkuo/ClickBench/blob/datafusion/datafusion/README.md) (run.sh is for generating the results we need to put in result json) here's the results: ```bash ----------------------------------------- 1. SELECT COUNT(*) FROM hits; ----------------------------------------- DataFusion CLI v10.0.0 0 rows in set. Query took 0.046 seconds. +-----------------+ | COUNT(UInt8(1)) | +-----------------+ | 99997497 | +-----------------+ 1 row in set. Query took 0.378 seconds. ----------------------------------------- 2. 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.321 seconds. ----------------------------------------- 3. SELECT SUM("AdvEngineID"), COUNT(*), AVG("ResolutionWidth") FROM hits; ----------------------------------------- DataFusion CLI v10.0.0 0 rows in set. Query took 0.037 seconds. +-----------------------+-----------------+---------------------------+ | SUM(hits.AdvEngineID) | COUNT(UInt8(1)) | AVG(hits.ResolutionWidth) | +-----------------------+-----------------+---------------------------+ | 7280088 | 99997497 | 1513.4879349030107 | +-----------------------+-----------------+---------------------------+ 1 row in set. Query took 0.842 seconds. ----------------------------------------- 4. SELECT AVG("UserID") FROM hits; ----------------------------------------- DataFusion CLI v10.0.0 0 rows in set. Query took 0.037 seconds. +---------------------+ | AVG(hits.UserID) | +---------------------+ | 2528953029789717000 | +---------------------+ 1 row in set. Query took 0.515 seconds. ----------------------------------------- 5. SELECT COUNT(DISTINCT "UserID") FROM hits; ----------------------------------------- DataFusion CLI v10.0.0 0 rows in set. Query took 0.044 seconds. +-----------------------------+ | COUNT(DISTINCT hits.UserID) | +-----------------------------+ | 17630976 | +-----------------------------+ 1 row in set. Query took 3.921 seconds. ----------------------------------------- 6. SELECT COUNT(DISTINCT "SearchPhrase") FROM hits; ----------------------------------------- DataFusion CLI v10.0.0 0 rows in set. Query took 0.044 seconds. thread 'tokio-runtime-worker' panicked at 'range end index 120 out of range for slice of length 104', library/core/src/slice/index.rs:73:5 note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace thread 'tokio-runtime-worker' panicked at 'range end index 87 out of range for slice of length 80', library/core/src/slice/index.rs:73:5 ArrowError(ExternalError(Execution("Join Error: task 43 panicked"))) ----------------------------------------- 7. 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.349 seconds. ----------------------------------------- 8. 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.041 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.331 seconds. ----------------------------------------- 9. 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.037 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.839 seconds. ----------------------------------------- 10. 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.043 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.069 seconds. ----------------------------------------- 11. 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.045 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.938 seconds. ----------------------------------------- 12. 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.043 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.274 seconds. ----------------------------------------- 13. 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.043 seconds. thread 'tokio-runtime-worker' panicked at 'range end index 120 out of range for slice of length 104', library/core/src/slice/index.rs:73:5 note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace thread 'tokio-runtime-worker' panicked at 'range end index 87 out of range for slice of length 80', library/core/src/slice/index.rs:73:5 ArrowError(ExternalError(ArrowError(ExternalError(Execution("Join Error: task 43 panicked"))))) ----------------------------------------- 14. 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.040 seconds. thread 'tokio-runtime-worker' panicked at 'range end index 128 out of range for slice of length 112', library/core/src/slice/index.rs:73:5 note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace thread 'tokio-runtime-worker' panicked at 'range end index 95 out of range for slice of length 88', library/core/src/slice/index.rs:73:5 ArrowError(ExternalError(ArrowError(ExternalError(Execution("Arrow error: External error: Execution error: Join Error: task 75 panicked"))))) ----------------------------------------- 15. 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.043 seconds. thread 'tokio-runtime-worker' panicked at 'range end index 122 out of range for slice of length 104', library/core/src/slice/index.rs:73:5 note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace thread 'tokio-runtime-worker' panicked at 'range end index 89 out of range for slice of length 80', library/core/src/slice/index.rs:73:5 ArrowError(ExternalError(ArrowError(ExternalError(Execution("Join Error: task 43 panicked"))))) ----------------------------------------- 16. 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.040 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 5.740 seconds. ----------------------------------------- 17. 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.043 seconds. thread 'tokio-runtime-worker' panicked at 'range end index 128 out of range for slice of length 112', library/core/src/slice/index.rs:73:5 note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace thread 'ArrowError(ExternalError(ArrowError(ExternalError(Execution("Join Error: task 43 panicked"))))) tokio-runtime-worker' panicked at 'range end index 95 out of range for slice of length 88', library/core/src/slice/index.rs:73:5 ----------------------------------------- 18. SELECT "UserID", "SearchPhrase", COUNT(*) FROM hits GROUP BY "UserID", "SearchPhrase" LIMIT 10; ----------------------------------------- DataFusion CLI v10.0.0 0 rows in set. Query took 0.043 seconds. thread 'tokio-runtime-worker' panicked at 'range end index 128 out of range for slice of length 112', library/core/src/slice/index.rs:73:5 note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace ArrowError(ExternalError(Execution("Join Error: task 43 panicked"))) thread 'tokio-runtime-worker' panicked at 'range end index 95 out of range for slice of length 88', library/core/src/slice/index.rs:73:5 ----------------------------------------- 19. 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.039 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.") ----------------------------------------- 20. SELECT "UserID" FROM hits WHERE "UserID" = 435090932899640449; ----------------------------------------- DataFusion CLI v10.0.0 0 rows in set. Query took 0.041 seconds. +--------------------+ | UserID | +--------------------+ | 435090932899640449 | | 435090932899640449 | | 435090932899640449 | | 435090932899640449 | +--------------------+ 4 rows in set. Query took 0.441 seconds. ----------------------------------------- 21. SELECT COUNT(*) FROM hits WHERE "URL" LIKE '%google%'; ----------------------------------------- DataFusion CLI v10.0.0 0 rows in set. Query took 0.040 seconds. +-----------------+ | COUNT(UInt8(1)) | +-----------------+ | 15908 | +-----------------+ 1 row in set. Query took 9.454 seconds. ----------------------------------------- 22. 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.044 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 12.830 seconds. ----------------------------------------- 23. 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.044 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 34.372 seconds. ----------------------------------------- 24. SELECT README.md b.sql benchmark.sh convert-r.py create.sql hits.parquet queries-fix2.sql queries-full.sql queries.sql r.txt r2.txt result.csv run.sh run2.sh FROM hits WHERE "URL" LIKE '%google%' ORDER BY "EventTime" LIMIT 10; ----------------------------------------- DataFusion CLI v10.0.0 0 rows in set. Query took 0.043 seconds. SQL(ParserError("Expected end of statement, found: .")) ----------------------------------------- 25. SELECT "SearchPhrase" FROM hits WHERE "SearchPhrase" <> '' ORDER BY "EventTime" LIMIT 10; ----------------------------------------- DataFusion CLI v10.0.0 0 rows in set. Query took 0.043 seconds. +------------------------------------+ | SearchPhrase | +------------------------------------+ | galaxy s4 zoom фильм | | симптомы регистратов | | фильм небольшой бизнеса североятно | | ночно китая женщины | | авом констеть ребенка краево | | компьютерапии серия нарий | | расписание мультиварка для | | отдыха чем прокат | | скачать читалию в духовке | | анапа оперевянные волшебную | +------------------------------------+ 10 rows in set. Query took 4.899 seconds. ----------------------------------------- 26. SELECT "SearchPhrase" FROM hits WHERE "SearchPhrase" <> '' ORDER BY "SearchPhrase" LIMIT 10; ----------------------------------------- DataFusion CLI v10.0.0 0 rows in set. Query took 0.043 seconds. +-----------------------------------------+ | SearchPhrase | +-----------------------------------------+ | береж | | за русский стил видео какой | | завод тандалищные прода | | заочное по земли в обрезни и метро | | заочное сад цены нарощения музыка визу | | зве | | земные огурцы раб | | золотой сайт samsung | | прав | | светы женске 2 сезон | +-----------------------------------------+ 10 rows in set. Query took 10.611 seconds. ----------------------------------------- 27. SELECT "SearchPhrase" FROM hits WHERE "SearchPhrase" <> '' ORDER BY "EventTime", "SearchPhrase" LIMIT 10; ----------------------------------------- DataFusion CLI v10.0.0 0 rows in set. Query took 0.043 seconds. +------------------------------------+ | SearchPhrase | +------------------------------------+ | galaxy s4 zoom фильм | | ночно китая женщины | | симптомы регистратов | | фильм небольшой бизнеса североятно | | авом констеть ребенка краево | | анапа оперевянные волшебную | | брита ганам котлы на шерлок | | компьютерапии серия нарий | | отдыха чем прокат | | расписание мультиварка для | +------------------------------------+ 10 rows in set. Query took 9.118 seconds. ----------------------------------------- 28. 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.044 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 20.399 seconds. ----------------------------------------- 29. 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.077 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:%2F%2Fviewtopic | 20 | 391115 | http:%2F%2Fviewtopic | | http://holodilnik.ru | 20 | 133893 | http://holodilnik.ru | | http://smeshariki.ru | 20 | 210736 | http://smeshariki.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 681.318 seconds. ----------------------------------------- 30. 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.110 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 11.450 seconds. ----------------------------------------- 31. 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.112 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 | -1125673878 | 1058 | 22 | 1587 | +----------------+-------------+------+---------------------+---------------------------+ 10 rows in set. Query took 17.790 seconds. ----------------------------------------- 32. 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.107 seconds. +---------------------+-------------+---+---------------------+---------------------------+ | WatchID | ClientIP | c | SUM(hits.IsRefresh) | AVG(hits.ResolutionWidth) | +---------------------+-------------+---+---------------------+---------------------------+ | 5639783218330720430 | 1794154196 | 1 | 1 | 1368 | | 6192312418584519843 | 1794154196 | 1 | 0 | 1368 | | 4939383509093326690 | 1190860152 | 1 | 0 | 1638 | | 6362607697319075992 | 1190860152 | 1 | 1 | 1638 | | 8597497404494430913 | 525299729 | 1 | 1 | 1087 | | 6811347515867936139 | -2031623971 | 1 | 0 | 1638 | | 6362706331538820401 | 2086141120 | 1 | 1 | 253 | | 5591505951833012084 | 1193505452 | 1 | 0 | 1638 | | 5936755026575390971 | 2001445642 | 1 | 0 | 1828 | | 6628772265126493981 | 787682966 | 1 | 0 | 1368 | +---------------------+-------------+---+---------------------+---------------------------+ 10 rows in set. Query took 18.089 seconds. ----------------------------------------- 33. 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.092 seconds. +---------------------+-------------+---+---------------------+---------------------------+ | WatchID | ClientIP | c | SUM(hits.IsRefresh) | AVG(hits.ResolutionWidth) | +---------------------+-------------+---+---------------------+---------------------------+ | 7904046282518428963 | 1509330109 | 2 | 0 | 1368 | | 8566928176839891583 | -1402644643 | 2 | 0 | 1368 | | 7224410078130478461 | -776509581 | 2 | 0 | 1368 | | 6655575552203051303 | 1611957945 | 2 | 0 | 1638 | | 6490075056285939109 | 1281592733 | 1 | 0 | 1750 | | 4881997672397396483 | 1281592733 | 1 | 1 | 1750 | | 7053567478887045102 | 1281592733 | 1 | 1 | 1750 | | 8650733771763992182 | -171972925 | 1 | 1 | 1917 | | 5778220860438315490 | -171972925 | 1 | 0 | 1917 | | 6476023165719163408 | -171972925 | 1 | 1 | 1917 | +---------------------+-------------+---+---------------------+---------------------------+ 10 rows in set. Query took 116.215 seconds. ----------------------------------------- 34. 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.094 seconds. thread 'tokio-runtime-worker' panicked at 'range end index 104 out of range for slice of length 88', library/core/src/slice/index.rs:73:5 note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace ArrowError(ExternalError(ArrowError(ExternalError(Execution("Join Error: task 39 panicked"))))) ----------------------------------------- 35. 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.091 seconds. thread 'tokio-runtime-worker' panicked at 'range end index 112 out of range for slice of length 96', library/core/src/slice/index.rs:73:5 note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace ArrowError(ExternalError(ArrowError(ExternalError(Execution("Join Error: task 39 panicked"))))) ----------------------------------------- 36. 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.093 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 9.963 seconds. ----------------------------------------- 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; ----------------------------------------- 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") ----------------------------------------- 38. 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.092 seconds. Plan("'UInt16 >= Utf8' can't be evaluated because there isn't a common type to coerce the types to") ----------------------------------------- 39. 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.092 seconds. Plan("'UInt16 >= Utf8' can't be evaluated because there isn't a common type to coerce the types to") ----------------------------------------- 40. 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.092 seconds. Plan("'UInt16 >= Utf8' can't be evaluated because there isn't a common type to coerce the types to") ----------------------------------------- 41. 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.091 seconds. Plan("'UInt16 >= Utf8' can't be evaluated because there isn't a common type to coerce the types to") ----------------------------------------- 42. 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.092 seconds. Plan("'UInt16 >= Utf8' can't be evaluated because there isn't a common type to coerce the types to") ----------------------------------------- 43. 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.092 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]
