{"id":73358,"date":"2020-03-09T08:42:14","date_gmt":"2020-03-09T05:42:14","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/clickhouse-vizualno-bystryj-i-naglyadnyj-analiz-dannyh-v-tabix-igor-stryhar"},"modified":"2020-03-09T08:42:14","modified_gmt":"2020-03-09T05:42:14","slug":"clickhouse-vizualno-bystryj-i-naglyadnyj-analiz-dannyh-v-tabix-igor-stryhar","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/clickhouse-vizualno-bystryj-i-naglyadnyj-analiz-dannyh-v-tabix-igor-stryhar","title":{"rendered":"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><strong>Ju ftoj t\u00eb njiheni me interpretimin e raportit t\u00eb vitit 2017 nga Igor Strychar \u00abClickHouse \u2013 nj\u00eb analiz\u00eb e shpejt\u00eb dhe vizuale e t\u00eb dh\u00ebnave n\u00eb Tabix\u00bb.<\/strong><\/p>\n<p><\/p>\n<p>Nd\u00ebrfaqja web p\u00ebr ClickHouse n\u00eb projektin Tabix.<br \/>\nFunksionalitetet kryesore:<\/p>\n<p><\/p>\n<ul>\n<li>Punon me ClickHouse drejtp\u00ebrdrejt nga shfletuesi, pa nevoj\u00ebn p\u00ebr t\u00eb instaluar softuer t\u00eb shtuar;<\/li>\n<li>Redaktori i pyetjeve me p\u00ebrmbledhje sintaksore;<\/li>\n<li>Auto-sugjerimi i komandave;<\/li>\n<li>Mjetet p\u00ebr analiz\u00ebn grafike t\u00eb ekzekutimit t\u00eb pyetjeve;<\/li>\n<li>Skemat e ngjyrave p\u00ebr zgjedhje.<br \/>\n<img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/9d95cf5ceb5acc3a1301943165ca9225.png\" style=\"display:block;margin: 0 auto;\" \/><\/li>\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><br \/>\n<center><div class=\"youtube-placeholder\" data-id=\"w1-XsL3nbRg\" onclick=\"loadVideo(this)\">\r\n        <img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/w1-XsL3nbRg\/hqdefault.jpg\" alt=\"Luaj videon\" loading=\"lazy\" width=\"480\" height=\"360\" style=\"width:100%;height:auto;\">\r\n        <div class=\"play-button\"><\/div>\r\n    <\/div><\/center><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/950e3d0a3ff10d267ae48e897f5cbdb6.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Un\u00eb jam drejtor teknik i SMI2. Ne jemi nj\u00eb agregator i shk\u00ebmbimit t\u00eb lajmeve. Ne ruajm\u00eb shum\u00eb t\u00eb dh\u00ebna q\u00eb i marrim nga partner\u00ebt tan\u00eb dhe i regjistrojm\u00eb n\u00eb ClickHouse \u2013 rreth 30,000 pyetje n\u00eb sekond\u00eb.<\/p>\n<p><\/p>\n<p>K\u00ebto jan\u00eb t\u00eb dh\u00ebna si:<\/p>\n<p><\/p>\n<ul>\n<li>Klikimet mbi lajmet.<\/li>\n<li>Shikimet e lajmeve n\u00eb agregator.<\/li>\n<li>Shikimet e baner\u00ebve n\u00eb rrjetin ton\u00eb.<\/li>\n<li>Dhe regjistrojm\u00eb ngjarje nga num\u00ebruesi yn\u00eb t\u00eb vetin, i ngjash\u00ebm me Yandex.Metrika. Kjo \u00ebsht\u00eb mikro-analitika jon\u00eb. <\/li>\n<\/ul>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/8f5a7af9fef04a51fed29279557c3b64.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Kemi pasur nj\u00eb jet\u00eb shum\u00eb t\u00eb trazuar para ClickHouse. Jemi munduar shum\u00eb duke u p\u00ebrpjekur t'i ruajm\u00eb k\u00ebto t\u00eb dh\u00ebna diku dhe t'i analizojm\u00eb ato si\u00e7 duhet.<\/p>\n<p><\/p>\n<p><strong>Jeta para ClickHouse \u2013 infiniDB<\/strong><\/p>\n<p><\/p>\n<p>E para gj\u00eb q\u00eb kishim, ishte infiniDB. Ajo jetoi p\u00ebr 4 vjet. E nisim me shum\u00eb v\u00ebshtir\u00ebsi. <\/p>\n<p><\/p>\n<ul>\n<li>Ajo nuk mb\u00ebshtet klasterizimin ose sharding. Asnj\u00eb gj\u00eb e till\u00eb nuk \u00ebsht\u00eb aktivizuar nga kutia n\u00eb m\u00ebnyr\u00eb t\u00eb paracaktuar. <\/li>\n<li>Ajo kishte v\u00ebshtir\u00ebsi n\u00eb ngarkimin e t\u00eb dh\u00ebnave. Vet\u00ebm nj\u00eb mjet specifik konsol q\u00eb mund t\u00eb ngarkonte vet\u00ebm skedar\u00eb CSV dhe vet\u00ebm n\u00eb nj\u00eb m\u00ebnyr\u00eb shum\u00eb t\u00eb paqart\u00eb. <\/li>\n<li>Baza e t\u00eb dh\u00ebnave \u00ebsht\u00eb nj\u00ebgjyshe. Mund t\u00eb shkruaje ose t\u00eb lexoje. Por e mund\u00ebsonte t\u00eb p\u00ebrpunonte nj\u00eb volum t\u00eb madh t\u00eb dh\u00ebnash. <\/li>\n<li>Dhe kishte nj\u00eb zgjidhje interesante. \u00c7do nat\u00eb duhej t\u00eb rimbushnim serverin, ndryshe ai nuk funksiononte. <\/li>\n<\/ul>\n<p><\/p>\n<p>Ajo punoi p\u00ebr ne deri n\u00eb fund t\u00eb vitit 2016, kur ne kaluam plot\u00ebsisht n\u00eb ClickHouse.<\/p>\n<p><\/p>\n<p><strong>Jeta para ClickHouse \u2014 Cassandra<\/strong><\/p>\n<p><\/p>\n<p>Meqen\u00ebse infiniDB ishte nj\u00ebgjyshe, ne vendos\u00ebm se na duhej nj\u00eb baz\u00eb t\u00eb dh\u00ebnash shum\u00ebgjyshe n\u00eb t\u00eb cilin mund t\u00eb shkruanim shum\u00eb rrjedha nj\u00ebkoh\u00ebsisht.<\/p>\n<p><\/p>\n<p>Kemi provuar shum\u00eb gj\u00ebra interesante. Pastaj vendos\u00ebm t\u00eb provojm\u00eb Cassandra. Me Cassandra gjith\u00e7ka shkoi mrekullisht p\u00ebr ne. 10,000 k\u00ebrkesa n\u00eb sekond\u00eb p\u00ebr bast. Rreth 2,000 k\u00ebrkesa p\u00ebr lexim. <\/p>\n<p><\/p>\n<p>Por\u00eb, ajo kishte interesat e saj. Nj\u00eb her\u00eb n\u00eb muaj ose \u00e7do dy muaj ndodhte nj\u00eb desinkronizim i baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. Duhej t\u00eb zgjoheshim dhe t\u00eb vraponim p\u00ebr t\u00eb riparuar Cassandra. Rindiznim server\u00ebt nj\u00eb nga nj\u00eb. Pastaj gjith\u00e7ka b\u00ebhej e qet\u00eb dhe e bukur. <\/p>\n<p><\/p>\n<p><strong>Jeta para ClickHouse \u2013 Druid<\/strong><\/p>\n<p><\/p>\n<p>Pastaj e kuptuam se na duhej t\u00eb shkruanim m\u00eb shum\u00eb t\u00eb dh\u00ebna. N\u00eb vitin 2016 filluam t\u00eb shqyrtonim Druid. <\/p>\n<p><\/p>\n<p>Druid \u00ebsht\u00eb nj\u00eb baz\u00eb e hapur, e shkruar n\u00eb Java. Shum\u00eb specifike. Dhe ishte e p\u00ebrshtatshme p\u00ebr clickstream, kur na nevojitej t\u00eb ruanim nj\u00eb rrjedh\u00eb ngjarjesh dhe pastaj t\u00eb b\u00ebnim agregim ose t\u00eb krijonim raportet analitik\u00eb.<\/p>\n<p><\/p>\n<p>Druid kishte versionin 0.9.X. <\/p>\n<p><\/p>\n<p>Vet\u00eb baza e t\u00eb dh\u00ebnave instalohet shum\u00eb me v\u00ebshtir\u00ebsi. Kjo \u00ebsht\u00eb kompleksiteti i infrastruktur\u00ebs. P\u00ebr ta instaluar, duhej t\u00eb vendosnim shum\u00eb-m\u00eb shum\u00eb pajisje. Dhe \u00e7do pajisje ishte p\u00ebrgjegj\u00ebse p\u00ebr rolin e saj t\u00eb ve\u00e7ant\u00eb. <\/p>\n<p><\/p>\n<p>P\u00ebr t\u00eb ngarkuar t\u00eb dh\u00ebnat n\u00eb t\u00eb, duhej t\u00eb aplikonim ndonj\u00eb magji. Ekziston nj\u00eb projekt OpenSource \u2013 Tranquility, i cili humbiste t\u00eb dh\u00ebnat n\u00eb rrjedh\u00eb. Kur i ngarkonim t\u00eb dh\u00ebnat n\u00eb t\u00eb, ato humbisnin. <\/p>\n<p><\/p>\n<p>Por ndonj\u00ebher\u00eb e filluam t\u00eb implementonim at\u00eb. Ne, si jelek\u00ebt, q\u00eb thitheshim, por vazhdojm\u00eb t\u00eb ham\u00eb kaktusin, filluam ta zbatonim. Na duhej rreth nj\u00eb muaj p\u00ebr t\u00eb p\u00ebrgatitur t\u00eb gjith\u00eb infrastruktur\u00ebn p\u00ebr t\u00eb. Kjo do t\u00eb thot\u00eb, t\u00eb porositnim servera, t\u00eb konfiguroni role, t\u00eb realizonim automatizimin e plot\u00eb t\u00eb zhvillimit. Kjo do t\u00eb thot\u00eb, n\u00eb rast t\u00eb r\u00ebnies s\u00eb klastra, q\u00eb nj\u00eb klaster tjet\u00ebr t\u00eb instalohej automatikisht. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/a8193aab09ab9cce3b69e3b84ce470dd.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Por ndodhi nj\u00eb mrekulli. Isha n\u00eb pushim, dhe koleg\u00ebt e mi m\u00eb d\u00ebrgojn\u00eb nj\u00eb lidhje n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/yandex\/blog\/303282\/\">habr<\/a><\/noindex>, ku flitet p\u00ebr faktin se Yandex vendosi t\u00eb hap\u00eb ClickHouse. Them se le t\u00eb provojm\u00eb.<\/p>\n<p><\/p>\n<p>Dhe p\u00ebr vet\u00ebm 2 dit\u00eb u zhvillua nj\u00eb klaster testimi ClickHouse. Filluan t\u00eb ngarkonin t\u00eb dh\u00ebna n\u00eb t\u00eb. Krahasuar me infiniDB \u2013 \u00ebsht\u00eb shum\u00eb e leht\u00eb, krahasuar me Druid \u2013 \u00ebsht\u00eb shum\u00eb e leht\u00eb. Krahasuar me Cassandra gjithashtu \u00ebsht\u00eb shum\u00eb e leht\u00eb. Sepse n\u00ebse ngarkon t\u00eb dh\u00ebnat nga php n\u00eb Cassandra, kjo nuk \u00ebsht\u00eb e leht\u00eb.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/0b4b6ea08f7f7037d0e26dbe3f33fa53.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>\u00c7far\u00eb mor\u00ebm? Performanc\u00eb n\u00eb shpejt\u00ebsi. Performanc\u00eb n\u00eb ruajtjen e t\u00eb dh\u00ebnave. Kjo do t\u00eb thot\u00eb se p\u00ebrdoret shum\u00eb m\u00eb pak hap\u00ebsir\u00eb disk. ClickHouse \u2013 \u00ebsht\u00eb i shpejt\u00eb, \u00ebsht\u00eb shum\u00eb i shpejt\u00eb krahasuar me produkte t\u00eb tjera. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/9ff5e2ac127be8813b5d5cec49dab73a.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>N\u00eb momentin e lan\u00e7imit, kur Yandex publikoi ClickHouse n\u00eb OpenSource, kishte vet\u00ebm nj\u00eb klient konsol\u00eb. Ne n\u00eb kompanin\u00eb ton\u00eb, SMI2, vendos\u00ebm t\u00eb provonim t\u00eb b\u00ebnim nj\u00eb klient natyral p\u00ebr web, q\u00eb t\u00eb mund t\u00eb hapnim nj\u00eb faqe nga shfletuesi, t\u00eb shkruanim nj\u00eb pyetje dhe t\u00eb merrnim rezultatin, sepse filluam t\u00eb shkruanim shum\u00eb pyetje. T\u00eb shkruash n\u00eb konsol\u00eb \u00ebsht\u00eb e v\u00ebshtir\u00eb. Dhe ne b\u00ebm\u00eb versionin ton\u00eb t\u00eb par\u00eb.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/a2569a45f9bf1b91815ca3dfa0eefcf3.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Dhe diku m\u00eb af\u00ebr dimrit t\u00eb kaluar, filluan t\u00eb shfaqen mjete t\u00eb tjera p\u00ebr t\u00eb punuar me ClickHouse. K\u00ebto jan\u00eb mjete si:<\/p>\n<p><\/p>\n<ul>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/redash.io\/\">Redash.IO<\/a><\/noindex>.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/zeppelin.apache.org\/\">Apache Zeppelin<\/a><\/noindex>.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/airbnb\/incubator-superset\">Superset Airbnb<\/a><\/noindex>. (Tani <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/apache\/incubator-superset\">https:\/\/github.com\/apache\/incubator-superset<\/a><\/noindex>)<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/blog.jetbrains.com\/datagrip\/2018\/08\/15\/datagrip-2018-2-2-clickhouse-support-and-bugfixes\/\">Jetbrains IDE<\/a><\/noindex>.<\/li>\n<li><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/Vertamedia\/clickhouse-grafana\">Vertamedia\/clickhouse-grafana<\/a><\/noindex>. <\/li>\n<\/ul>\n<p><\/p>\n<p>Do t\u00eb shqyrtoj disa nga k\u00ebto mjete, dmth. ato me t\u00eb cilat kam punuar. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/7b91bc29b1c04020b56c89621287e8c1.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Nj\u00eb instrument i mir\u00eb, por p\u00ebr Druid. Kur implementova Druid, e shqyrtova SuperSet. M\u00eb p\u00eblqeu. P\u00ebr Druid funksionon shum\u00eb shpejt. <\/p>\n<p><\/p>\n<p>P\u00ebr ClickHouse nuk \u00ebsht\u00eb i p\u00ebrshtatsh\u00ebm. Dmth. \u00ebsht\u00eb i p\u00ebrshtatsh\u00ebm, funksionon, por \u00ebsht\u00eb gati t\u00eb p\u00ebrpunoj\u00eb vet\u00ebm pyetje elementare si: SELECT event, GROUP BY event. Ai nuk mb\u00ebshtet sintaks\u00ebn m\u00eb t\u00eb komplikuar t\u00eb ClickHouse.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/a708c787120de3db725a9bba4c8bd642.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Instrumenti tjet\u00ebr \u2013 Apache Zeppelin. \u00cbsht\u00eb nj\u00eb gj\u00eb e mir\u00eb dhe interesante. Funksionon. Ai mb\u00ebshtet sh\u00ebnime, panele monitorimi, mb\u00ebshtet variablat. Di q\u00eb dikush nga komuniteti ClickHouse e p\u00ebrdor. <\/p>\n<p><\/p>\n<p>Porosie t\u00eb sintaks\u00ebs ClickHouse nuk \u00ebsht\u00eb e mb\u00ebshtetur, q\u00eb do t\u00eb thot\u00eb se do t\u00eb duhet t\u00eb shkruani k\u00ebrkesat ose n\u00eb konsol\u00eb, ose diku tjet\u00ebr. M\u00eb pas, duhet t\u00eb verifikoni n\u00ebse gjith\u00e7ka funksionon. Kjo \u00ebsht\u00eb thjesht e pak\u00ebndshme. Por mb\u00ebshtetja p\u00ebr dashboard \u00ebsht\u00eb shum\u00eb e mir\u00eb. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/0c2afefc1504d14dd50f88459a652a1c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Arsyeja tjet\u00ebr \u2013 \u00ebsht\u00eb Redash.IO. Redash \u00ebsht\u00eb i hostuar n\u00eb internet. Kjo do t\u00eb thot\u00eb se ndryshe nga mjetet e m\u00ebparshme, nuk \u00ebsht\u00eb e nevojshme ta instaloni. Ky \u00ebsht\u00eb nj\u00eb d\u00ebshtim me mund\u00ebsi konsolidimi t\u00eb t\u00eb dh\u00ebnave nga burime t\u00eb ndryshme. K\u00ebshtu q\u00eb mund t\u00eb t\u00ebrheqni t\u00eb dh\u00ebna nga ClickHouse, MySQL, PostgreSQL dhe nga baza t\u00eb tjera t\u00eb dh\u00ebnash. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/dc639fe6e9716c835d1fe0fdfaa300b8.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Pik\u00ebrisht nj\u00eb muaj m\u00eb par\u00eb (n\u00eb mars 2017) u prezantua mb\u00ebshtetja n\u00eb Grafana. Kur nd\u00ebrroni raporte n\u00eb Grafana, p\u00ebr shembull, p\u00ebr gjendjen e pajisjeve tuaja ose p\u00ebr ndonj\u00eb metrik\u00eb, tani \u00ebsht\u00eb e mundur t\u00eb nd\u00ebrtoni nj\u00eb grafik t\u00eb ngjash\u00ebm ose ndonj\u00eb panel nga t\u00eb dh\u00ebnat nga ClickHouse direkt. Kjo \u00ebsht\u00eb shum\u00eb e k\u00ebndshme dhe ne e p\u00ebrdorim n\u00eb sistemin ton\u00eb. Kjo lejon gjetjen e anomalive. K\u00ebshtu q\u00eb, n\u00ebse ndodh di\u00e7ka dhe ndonj\u00eb pajisje bie ose ndjehet e ngarkuar, mund t\u00eb shihni arsyen, p\u00ebrsa koh\u00eb k\u00ebto t\u00eb dh\u00ebna kan\u00eb arritur n\u00eb ClickHouse. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/0dd54a7633d25d0c924c2e6825028eb3.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>M\u00eb dukej shum\u00eb e pak\u00ebndshme t\u00eb shkruaja n\u00eb k\u00ebto mjete ose n\u00eb konsol\u00eb. K\u00ebshtu q\u00eb kam vendosur t\u00eb p\u00ebrmir\u00ebsoj nd\u00ebrfaqen ton\u00eb t\u00eb par\u00eb. Kam marr\u00eb iden\u00eb nga EventSQL, SeperSet, Zeppelin.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/3252a09e0942428143336639aa399f4d.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>\u00c7far\u00eb do t\u00eb kishit? Doja t\u00eb merrja grafik\u00ebt, nj\u00eb redaktues t\u00eb avancuar, t\u00eb implementoja mb\u00ebshtetje p\u00ebr fjalor\u00ebt e sugjerimeve. Sepse ClickHouse ka nj\u00eb funksion t\u00eb shk\u00eblqyer - jan\u00eb fjalor\u00ebt. Por \u00ebsht\u00eb e v\u00ebshtir\u00eb t\u00eb punosh me fjalor\u00ebt, sepse duhet t\u00eb mbash mend formatin e vlerave t\u00eb ruajtur, dmth. \u00ebsht\u00eb num\u00ebr apo string etj. Dhe pasi q\u00eb shpesh i p\u00ebrdorim fjalor\u00ebt n\u00eb variacionet e tyre t\u00eb ndryshme, ishte mjaft e v\u00ebshtir\u00eb t\u00eb shkruaja pyetje.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/90a529b4fb5d03a6d61c89e00287b21d.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Kan\u00eb kaluar 3 muaj nga l\u00ebshimi i versionit ton\u00eb t\u00eb par\u00eb. Kam b\u00ebr\u00eb rreth 330 komit\u00eb n\u00eb deg\u00ebn e mbyllur dhe ka dal\u00eb Tabix.<\/p>\n<p><\/p>\n<p>N\u00eb krahasim me versionin e kaluar, i cili quhej ClickHouse-Frontend, vendosa ta riem\u00ebroj n\u00eb nj\u00eb em\u00ebr m\u00eb t\u00eb thjesht\u00eb. Dhe ashtu doli Tabix.<\/p>\n<p><\/p>\n<p>\u00c7far\u00eb ka dal\u00eb?<\/p>\n<p><\/p>\n<p>Vizaton grafik\u00ebt. Mb\u00ebshtet sintaks\u00ebn SQL t\u00eb ClickHouse. Jep sugjerime p\u00ebr funksionet dhe ka shum\u00eb gj\u00ebra interesante q\u00eb di t\u00eb b\u00ebj\u00eb.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/cd2bbb0c2c3e0fa2d2622bbd2aecdbc7.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>K\u00ebtu \u00ebsht\u00eb skema e p\u00ebrgjithshme e Tabix. N\u00eb maj\u00eb paraqitet nj\u00eb pem\u00eb. N\u00eb qend\u00ebr - \u00ebsht\u00eb redaktori i pyetjes. Dhe posht\u00eb - \u00ebsht\u00eb rezultati i k\u00ebsaj pyetje.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/becf5df173220480e077ae8d8e0ebf3e.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>M\u00eb pas do t'ju tregoj se si funksionon redaktori i pyetjeve. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/d5ca1028922a12d5e6f133704d4c91a2.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>K\u00ebtu automatikisht ka funksionuar auto-k kompletimi n\u00eb tabel\u00eb dhe jep sugjerime p\u00ebrkat\u00ebse, si auto-k kompletimi p\u00ebr fushat. Dhe sugjerimet p\u00ebr funksionet. N\u00ebse shtypni ctrl + enter, k\u00ebrkesa do t\u00eb ekzekutohet ose do t\u00eb ndodh\u00eb nj\u00eb gabim. K\u00ebrkesa m\u00eb e thjesht\u00eb d\u00ebrgohet n\u00eb Tabix dhe merrni rezultatin, dometh\u00ebn\u00eb, mund t\u00eb punoni shpejt me ClickHouse.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/74623f9f5030eb08523dc7269517a5d5.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Fjalor\u00ebt, si\u00e7 e thash\u00eb, jan\u00eb nj\u00eb gj\u00eb shum\u00eb interesante, me t\u00eb cil\u00ebn ne punojm\u00eb shum\u00eb. Dhe q\u00eb na ka lejuar t\u00eb b\u00ebjm\u00eb shum\u00eb gj\u00ebra. P\u00ebr shembull, n\u00eb fjalor\u00eb ruajm\u00eb t\u00eb gjitha qytetet. Ruajm\u00eb identifikuesin e qytetit dhe emrin e qytetit, gjer\u00ebsin\u00eb dhe gjat\u00ebsi. Nd\u00ebrsa n\u00eb baz\u00eb ruajm\u00eb vet\u00ebm identifikuesin e qytetit. Prandaj, ne i kompresojm\u00eb t\u00eb dh\u00ebnat shum\u00eb.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/fa698b916b01a58f182003e6a15dfea0.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Kjo duket si nj\u00eb gj\u00eb e thjesht\u00eb, por n\u00eb ClickHouse ajo ndihmon n\u00eb m\u00ebnyr\u00eb shum\u00eb interesante. P\u00ebr shkak se ClickHouse mb\u00ebshtet vet\u00ebm bashkime t\u00eb thelluara, k\u00ebrkesa rritet ndjesh\u00ebm n\u00eb lart\u00ebsi dhe gjer\u00ebsi. Kur hapet nj\u00eb kllap\u00eb dhe vazhdon me nj\u00eb shprehje t\u00eb gjat\u00eb, nj\u00eb gj\u00eb e till\u00eb e thjesht\u00eb si p\u00ebrmbledhja e k\u00ebrkes\u00ebs ndihmon p\u00ebr ta b\u00ebr\u00eb pun\u00ebn me k\u00ebrkes\u00ebn m\u00eb t\u00eb leht\u00eb. Sepse kur k\u00ebrkesa ka 200-300 rreshta dhe \u00ebsht\u00eb shum\u00eb e gjer\u00eb, p\u00ebrmbledhja e k\u00ebrkes\u00ebs \u00ebsht\u00eb shp\u00ebtim dhe ndihmon p\u00ebr t\u00eb gjetur nj\u00eb vend ose p\u00ebr ta lokalizuar.<\/p>\n<p><\/p>\n<p>Pema e objekteve, shum\u00ebk\u00ebrkesat dhe tabet (Video 13:46) <noindex><a rel=\"nofollow\" href=\"https:\/\/youtu.be\/w1-XsL3nbRg?t=826\">https:\/\/youtu.be\/w1-XsL3nbRg?t=826<\/a><\/noindex>)<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/d43efecc6b0b395cdc17a3dd9db53400.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Tani do t\u00eb tregoj p\u00ebr pem\u00ebn, tabet. N\u00eb t\u00eb majt\u00eb \u2013 kjo \u00ebsht\u00eb pema, dhe lart mund t\u00eb krijoni disa tab. Tabet jan\u00eb si nj\u00eb vend pune. Mund t\u00eb krijoni disa tab dhe \u00e7do nj\u00ebri ta em\u00ebrtoni sipas d\u00ebshir\u00ebs. Kjo \u00ebsht\u00eb si nj\u00eb mini sistem p\u00ebr nd\u00ebrtimin e raportit.<\/p>\n<p><\/p>\n<p>Tabet ruajn\u00eb automatikisht. N\u00ebse rindizni shfletuesin tuaj ose e mbyllni, ose hapni Tabix, t\u00eb gjitha k\u00ebto do t\u00eb ruajn\u00eb.<\/p>\n<p><\/p>\n<p>Celesi i shpejt\u00eb \u2013 i dobish\u00ebm (Video 14:39) <noindex><a rel=\"nofollow\" href=\"https:\/\/youtu.be\/w1-XsL3nbRg?t=879\">https:\/\/youtu.be\/w1-XsL3nbRg?t=879<\/a><\/noindex>)<\/p>\n<p><\/p>\n<p>Ka shum\u00eb celesa t\u00eb shpejt\u00eb dhe un\u00eb kam nxjerr\u00eb disa prej tyre k\u00ebtu si shembuj. K\u00ebto jan\u00eb p\u00ebr kalimin e tab, p\u00ebr t\u00eb ekzekutuar k\u00ebrkes\u00ebn ose p\u00ebr t\u00eb ekzekutuar disa k\u00ebrkesa. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/27f3e6d0dbb4d1038bb551808b13d2ac.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Do t\u00eb tregoj se si t\u00eb punoni me rezultatin. D\u00ebrgojm\u00eb k\u00ebrkes\u00ebn. K\u00ebtu vizatoj sin, cos dhe tg. Mund t\u00eb theksoj rezultatin, pra, t\u00eb vizatoj nj\u00eb hart\u00eb tipike p\u00ebr kolon\u00ebn. Mund t\u00eb theksoj vlerat pozitive ose negative. Ose thjesht t\u00eb koloroj ndonj\u00eb element specifik t\u00eb tabel\u00ebs. Kjo \u00ebsht\u00eb e dobishme kur tabela \u00ebsht\u00eb e madhe dhe duhet t\u00eb gjej ndonj\u00eb anomali me sy. Kur k\u00ebrkoja anomali, theksoja disa rreshta, disa element\u00eb me ngjyr\u00eb t\u00eb gjelb\u00ebr ose t\u00eb kuqe.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/af0c21073a1edd81e4d688f119ef7568.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Ka shum\u00eb gj\u00ebra interesante aty. P\u00ebr shembull, si t\u00eb kopjoni n\u00eb Redmine Markdown. N\u00ebse duhet t\u00eb kopjoni rezultatin diku, kjo \u00ebsht\u00eb shum\u00eb e dobishme. Mund t\u00eb thjesht t\u00eb p\u00ebrzgjidhni zon\u00ebn, t\u00eb thoni \"Copy to Redmine\" dhe ai do ta kopjoj\u00eb n\u00eb Redmine Markdown ose do t\u00eb krijoj\u00eb nj\u00eb k\u00ebrkes\u00eb Where.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/43034a47b5ca31ee08e7721cc5f5159c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>M\u00eb pas \u00ebsht\u00eb optimizimi i pyetjeve. Nj\u00eb her\u00eb e harrova t\u00eb specifikoj fush\u00ebn \"date\". Dhe pyetja ime n\u00eb ClickHouse u p\u00ebrpunua mjaft shpejt, pra m\u00eb pak se nj\u00eb sekond\u00eb. Kur pash\u00eb sa shum\u00eb rreshta kalon, mu b\u00eb frik\u00eb. Ne brenda nj\u00eb dite nuk shkruajm\u00eb aq shum\u00eb rreshta n\u00eb k\u00ebt\u00eb tabel\u00eb. Fillova t\u00eb analizoj pyetjen dhe pash\u00eb se kisha humbur dat\u00ebn n\u00eb nj\u00eb vend. Pra, harrova t\u00eb specifikoj se m\u00eb duhen t\u00eb dh\u00ebnat jo p\u00ebr t\u00eb gjith\u00eb tabel\u00ebn, por p\u00ebr nj\u00eb periudh\u00eb t\u00eb caktuar.<\/p>\n<p><\/p>\n<p>N\u00eb Tabix ka nj\u00eb sked\u00eb \"Stats\", ku ruhet e gjith\u00eb historia e pyetjeve t\u00eb d\u00ebrguara, pra aty mund t\u00eb shikoni se sa shum\u00eb rreshta jan\u00eb lexuar nga kjo pyetje dhe sa koh\u00eb ka zgjatur ajo. Kjo lejon optimizimin. <\/p>\n<p><\/p>\n<p>Mund t\u00eb nd\u00ebrtoni nj\u00eb tabel\u00eb p\u00ebrmbledh\u00ebse mbi rezultatin e pyetjes. Ju d\u00ebrguat nj\u00eb pyetje n\u00eb ClickHouse, mor\u00ebt disa t\u00eb dh\u00ebna. M\u00eb pas k\u00ebto t\u00eb dh\u00ebna mund t'i l\u00ebvizni me miun dhe t\u00eb nd\u00ebrtoni nj\u00eb tabel\u00eb p\u00ebrmbledh\u00ebse.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/0365df303eb55336eeb8a037cb118113.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Gj\u00ebja tjet\u00ebr interesante \u00ebsht\u00eb nd\u00ebrtimi i grafik\u00ebve. Le t\u00eb themi, kemi k\u00ebt\u00eb pyetje: p\u00ebr sin, cos nga 0 deri n\u00eb 299. Dhe p\u00ebr ta vizatuar, duhet t\u00eb zgjidhni sked\u00ebn \"Draw\" dhe do t\u00eb merrni grafik me sin dhe cos tuaj. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/bdf00b9d6bffb907e88d2fdb7bfb16dc.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Kjo mund t\u00eb ndahet n\u00eb akse t\u00eb ndryshme, dmth. mund t\u00eb vizatoni dy grafik\u00eb ngjitur. Shkruani komand\u00ebn e par\u00eb dhe komand\u00ebn e dyt\u00eb. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/efe77846e3f5f30a5d73e75be53d608a.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Mund t\u00eb vizatoni histogramet.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/e531aac548eca2eb9e30dac21f8876b8.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Mund ta ndani k\u00ebt\u00eb n\u00eb nj\u00eb matric\u00eb grafik\u00ebsh.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/3404f87cee0e376df8ca62f03fc0fc7e.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Mund t\u00eb krijoni nj\u00eb hart\u00eb nxeht\u00ebsie. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/e15fe90c49bb850c821dab7492856b0b.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Mund t\u00eb krijoni nj\u00eb kalendar nxeht\u00ebsie. P\u00ebrve\u00e7 k\u00ebsaj, \u00ebsht\u00eb nj\u00eb gj\u00eb shum\u00eb e dobishme kur duhet t\u00eb analizohet anomalit\u00eb p\u00ebr nj\u00eb vit, dmth. t\u00eb gjeni ose shp\u00ebrthimet, ose r\u00ebniet. Kjo vizualizim e t\u00eb dh\u00ebnave m\u00eb ka ndihmuar n\u00eb k\u00ebt\u00eb. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/08945df379d33aa73518ef10d02fe561.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Gj\u00ebja tjet\u00ebr \u00ebsht\u00eb Treemap.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/a7331b33b77e98ce85aff0316e3dcc76.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/5794844e8c1db71f1507cbdae67fedf6.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Sankeys \u2013 nj\u00eb grafik interesant. Ai \u00ebsht\u00eb ose Streamgraphs, ose River. Por un\u00eb e quaj River. Ai gjithashtu lejon t\u00eb k\u00ebrkoni disa anomalit\u00eb. \u00cbsht\u00eb shum\u00eb i p\u00ebrshtatsh\u00ebm. Rekomandoj ta p\u00ebrdorni p\u00ebr k\u00ebrkimin.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/483f363d93ba80dc9ac165ae083db585.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Gj\u00ebja tjet\u00ebr interesante \u00ebsht\u00eb vizatimi i nj\u00eb harta dinamike. N\u00ebse n\u00eb baz\u00ebn tuaj t\u00eb t\u00eb dh\u00ebnave ruhen gjat\u00ebsia, gjer\u00ebsia dhe, le t\u00eb themi, \u00ebsht\u00eb ruajtur destinimi, n\u00ebse keni, p\u00ebr shembull, transport t\u00eb automjeteve ose avion\u00ebt fluturojn\u00eb, mund t\u00eb vizatoni rrug\u00ebt e destinacionit. Po ashtu, mund t\u00eb specifikoni shpejt\u00ebsin\u00eb, madh\u00ebsin\u00eb e k\u00ebtyre objekteve, n\u00eb t\u00eb cilat ato mb\u00ebrrijn\u00eb.<\/p>\n<p><\/p>\n<p>Por problemi me k\u00ebt\u00eb hart\u00eb \u00ebsht\u00eb se ajo vizaton vet\u00ebm hart\u00ebn e bot\u00ebs, nuk ka detaje.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/13f302e67e7f84dc85728204153d6377.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>M\u00eb pas, un\u00eb shtova Google Map. N\u00ebse mbani gjat\u00ebsin\u00eb dhe gjer\u00ebsin\u00eb, mund t\u00eb shfaqni rezultatin n\u00eb Google Map, por pa p\u00ebrkrahjen e avion\u00ebve.<\/p>\n<p><\/p>\n<p>Funksionet kryesore p\u00ebr pun\u00ebn me rezultatin dhe k\u00ebrkes\u00ebn n\u00eb Tabix i kemi diskutuar. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/849baa55e6865ab451b82f23fe6e5110.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>E ardhshmja \u00ebsht\u00eb analiza e serverit tuaj ClickHouse. Ka nj\u00eb sektion t\u00eb ve\u00e7ant\u00eb \"Metrix\", ku mund t\u00eb shihni madh\u00ebsin\u00eb e t\u00eb dh\u00ebnave t\u00eb ruajtura p\u00ebr \u00e7do kolon\u00eb. N\u00eb ekranin e kapur tregohet se kjo fush\u00eb \"referrer\" na merr rreth 730 GB. N\u00ebse heqim k\u00ebt\u00eb fush\u00eb, do t\u00eb kursejm\u00eb tre sharda prej 700 GB, q\u00eb do t\u00eb thot\u00eb rreth 2 TB, t\u00eb cilat nuk na nevojiten. <\/p>\n<p><\/p>\n<p>Po ashtu, kemi nj\u00eb fush\u00eb \"request_id\", t\u00eb cil\u00ebn e ruajm\u00eb si varg. Por n\u00ebse fillojm\u00eb ta ruajm\u00eb n\u00eb form\u00eb numerike, do ta kompresoj\u00eb k\u00ebt\u00eb fush\u00eb ndjesh\u00ebm. <\/p>\n<p><\/p>\n<p>Po ashtu, k\u00ebtu \u00ebsht\u00eb tregohet konfigurimi i serverit dhe lista e nod\u00ebve t\u00eb klasterit tuaj. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/fa2a35c1af59b3f56059fcfb26571c6e.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Sekioni tjet\u00ebr \u00ebsht\u00eb metrikat. Ato merret n\u00eb koh\u00eb reale nga ClickHouse dhe thjesht lejojn\u00eb t\u00eb analizoni gjendjen e serverit dhe t\u00eb kuptoni \u00e7far\u00eb po ndodh me t\u00eb. Kjo nuk \u00ebsht\u00eb z\u00ebvend\u00ebsim p\u00ebr nj\u00eb Grafana t\u00eb plot\u00eb. Kjo \u00ebsht\u00eb e nevojshme p\u00ebr t\u00eb analizuar shpejt. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/7de741718ef19b81bd0f7f33dbed019e.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Tabi tjet\u00ebr jan\u00eb proceset. Ato mund t\u00eb tregojn\u00eb se \u00e7far\u00eb po ndodh n\u00eb server. T\u00eb kuptosh se \u00e7far\u00eb po ndodh. Kam pasur nj\u00eb k\u00ebrkes\u00eb q\u00eb konsumonte 200 GB p\u00ebr lexim \u00e7do her\u00eb. E pash\u00eb k\u00ebt\u00eb p\u00ebrmes k\u00ebtij nd\u00ebrfaqe. E identifikova dhe e rregullova. Dhe arrita rreth 30 GB, dmth. performanca \u00ebsht\u00eb shum\u00eb m\u00eb e mir\u00eb.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiza vizuale e shpejt\u00eb dhe e qart\u00eb e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar\" src=\"\/wp-content\/uploads\/2020\/03\/084b6131b189364f9e093792125649df.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Faleminderit! Dhe kjo \u00ebsht\u00eb n\u00eb OpenSource<\/p>\n<p><\/p>\n<p>E p\u00ebrfundova. Dhe, p\u00ebr m\u00eb tep\u00ebr, kjo \u00ebsht\u00eb n\u00eb OpenSource, \u00ebsht\u00eb falas dhe as nuk duhet ta shkarkoni. Hapni n\u00eb shfletues dhe gjith\u00e7ka do t\u00eb funksionoj\u00eb. <\/p>\n<p><\/p>\n<p>Pyetje<\/p>\n<p><\/p>\n<p><em>Igor, \u00e7far\u00eb do t\u00eb b\u00ebsh m\u00eb pas? Ku do ta zhvillosh k\u00ebt\u00eb mjet?<\/em><\/p>\n<p><\/p>\n<p>Dhe m\u00eb pas do t\u00eb ket\u00eb nj\u00eb dashboard, dmth. ndoshta do t\u00eb ket\u00eb nj\u00eb dashboard. Integrim me bazat e tjera t\u00eb t\u00eb dh\u00ebnave. K\u00ebto i kam b\u00ebr\u00eb, por ende nuk i kam publikur n\u00eb OpenSource. Kjo \u00ebsht\u00eb MySQL dhe ndoshta PostgreSQL. Dmth. do t\u00eb jet\u00eb e mundur q\u00eb nga Tabix t\u00eb d\u00ebrgoni k\u00ebrkesa jo vet\u00ebm n\u00eb ClickHouse, por edhe n\u00eb mjete t\u00eb tjera.<\/p>\n<p><\/p>\n<p><em>Duket se \u00ebsht\u00eb b\u00ebr\u00eb nj\u00eb pun\u00eb e madhe. U krijua nj\u00eb ide mjaft e plot\u00eb. N\u00eb shfletues \u00ebsht\u00eb b\u00ebr\u00eb, duket, p\u00ebr t\u00eb eliminuar ndihmat n\u00eb axha dhe p\u00ebr t\u00eb nxjerr\u00eb gjith\u00e7ka shpejt. Kam d\u00ebgjuar q\u00eb ju po<\/em> <em>php<\/em> <em>Ju punoni, prandaj \u00ebsht\u00eb m\u00eb e leht\u00eb t\u00eb nisni n\u00eb shfletues dhe do t\u00eb funksionoj\u00eb kudo. N\u00eb k\u00ebt\u00eb nuk ka pyetje. Pyetja \u00ebsht\u00eb k\u00ebshtu. Ka shum\u00eb t\u00eb b\u00ebra me t\u00eb v\u00ebrtet\u00eb. Sa njer\u00ebz kan\u00eb punuar mbi k\u00ebt\u00eb? Dhe sa koh\u00eb ka marr\u00eb gjith\u00e7ka? Sepse mjetet p\u00ebr zakonisht nuk kan\u00eb kaq shum\u00eb funksionalitet.<\/em><\/p>\n<p><\/p>\n<p>Nga vera n\u00eb vjesht\u00eb ka punuar nj\u00eb person nga ekipi yn\u00eb. Kjo ishte versione e par\u00eb. M\u00eb pas, un\u00eb kam b\u00ebr\u00eb 330 komite. Ajo q\u00eb shihni, e kemi b\u00ebr\u00eb me kolegun tim. P\u00ebr 3 muaj nga versioni m\u00eb i par\u00eb deri n\u00eb versionin m\u00eb t\u00eb fundit, un\u00eb kam b\u00ebr\u00eb kryesisht. Por un\u00eb njoh shum\u00eb dob\u00ebt Javascript. Ky ishte projekti im i vet\u00ebm dhe, shpresoj, t\u00eb fundit q\u00eb kam punuar n\u00eb Javascript. M\u00eb erdhi, e shikova \u2013 o, tmerr. Por m\u00eb p\u00eblqente shum\u00eb ta p\u00ebrfundoj produktin dhe ja \u00e7far\u00eb doli.<\/p>\n<p><\/p>\n<p><em>Faleminderit shum\u00eb p\u00ebr referatin! Ky \u00ebsht\u00eb nj\u00eb mjet i shk\u00eblqyer. S<\/em> <em>Tableau<\/em> <em>krahasoni?<\/em><\/p>\n<p><\/p>\n<p>Faleminderit. Prandaj, Tabix e quajti k\u00ebshtu, sepse inicialet p\u00ebrputhen. <\/p>\n<p><\/p>\n<p><em>Sepse konkuroni?<\/em><\/p>\n<p><\/p>\n<p>Do t\u00eb ket\u00eb shum\u00eb investime, do t\u00eb konkurrojm\u00eb. <\/p>\n<p><\/p>\n<p><em>Si do t\u00eb propozonit ta shisni analist\u00ebve t\u00eb brendsh\u00ebm, q\u00eb ky mjet do t\u00eb z\u00ebvend\u00ebsoj\u00eb plot\u00ebsisht<\/em> *Tableau*<em>? \u041a\u0430\u043a\u0438\u0435 \u0431\u0443\u0434\u0443\u0442 \u0430\u0440\u0433\u0443\u043c\u0435\u043d\u0442\u044b?<\/em><\/p>\n<p><\/p>\n<p>Funksionon natyrsh\u00ebm me ClickHouse. Kam provuar Tableau, por atje nuk mund t\u00eb shkruhet mb\u00ebshtetje p\u00ebr fjalor\u00ebt dhe t\u00eb ngjashme. <strong>E di si punojn\u00eb njer\u00ebzit me Tabix. Ata shkruajn\u00eb nj\u00eb k\u00ebrkes\u00eb, e nxjerrin n\u00eb CSV dhe e ngarkojn\u00eb n\u00eb BI.<\/strong> Dhe atje b\u00ebjn\u00eb di\u00e7ka. Por v\u00ebshtir\u00eb e imagjinoj se si e b\u00ebjn\u00eb k\u00ebt\u00eb, sepse \u2013 \u00ebsht\u00eb nj\u00eb mjet grafik. Ai mund t\u00eb nxjerr\u00eb 5,000 rreshta, maksimumi 6,000 rreshta, por jo m\u00eb shum\u00eb, p\u00ebrndryshe shfletuesi nuk e duron. <\/p>\n<p><\/p>\n<p><em>Pra, ka disa kufizime serioze n\u00eb v\u00ebllimin e t\u00eb dh\u00ebnave, apo jo?<\/em><\/p>\n<p><\/p>\n<p>Po. Nuk e imagjinos dot se do t\u00eb d\u00ebshironit t\u00eb nxirrnin 10,000 rreshta n\u00eb nj\u00eb tabel\u00eb n\u00eb shfletues. Pse? <\/p>\n<p><\/p>\n<p><em>Nuk \u00ebsht\u00eb menduar q\u00eb ky t\u00eb jet\u00eb nj\u00eb nd\u00ebrfaqe p\u00ebr shikimin e shpejt\u00eb t\u00eb t\u00eb dh\u00ebnave? T\u00eb shikojm\u00eb pak, t\u00eb rrotullojm\u00eb?<\/em><\/p>\n<p><\/p>\n<p>Po, t\u00eb shikoni shpejt se si punon dhe thjesht t\u00eb nd\u00ebrtoni nj\u00eb grafik p\u00ebrmbledh\u00ebs. Pastaj ta d\u00ebrgoni diku. Ne kemi sistemin ton\u00eb t\u00eb raportimit, nga ku un\u00eb thjesht e marr k\u00ebt\u00eb k\u00ebrkes\u00eb. E vizatoj n\u00eb Tabix dhe e d\u00ebrgoj n\u00eb raportimin ton\u00eb. <\/p>\n<p><\/p>\n<p><em>Dhe nj\u00eb pyetje tjet\u00ebr. Analiz\u00eb e kohortave?<\/em><\/p>\n<p><\/p>\n<p>N\u00ebse ka k\u00ebrkesa, do ta shtojm\u00eb. <\/p>\n<p><\/p>\n<p><em>Kur filluam t\u00eb p\u00ebrdornim<\/em> <em>ClickHouse, sa koh\u00eb zgjati implementimi<\/em> <em>ClickHouse<\/em> <em>dhe gjetja n\u00eb<\/em> <em>gjendjen e prodhimit?<\/em><\/p>\n<p><\/p>\n<p>Sipas asaj q\u00eb thash\u00eb, ne kemi implementuar nj\u00eb klaster testues n\u00eb nj\u00eb koh\u00eb shum\u00eb t\u00eb shkurt\u00ebr. N\u00eb dy dit\u00eb e kemi vendosur. Dhe p\u00ebr disa jav\u00eb e kemi testuar. Dhe n\u00eb production arrit\u00ebm pas rreth 3 muajve. Por ne kishim ETL-n\u00eb ton\u00eb, dometh\u00ebn\u00eb nj\u00eb instrument p\u00ebr regjistrimin e t\u00eb dh\u00ebnave. Dhe ai shkruante n\u00eb gjith\u00e7ka q\u00eb mundej. Ai dinte t\u00eb shkruante n\u00eb MongoDB, Cassandra, MySQL. Ta m\u00ebsojm\u00eb t\u00eb shkruaj\u00eb n\u00eb ClickHouse ishte e thjesht\u00eb. Kishim infrastruktur\u00ebn e gatshme p\u00ebr nj\u00eb implementim t\u00eb shpejt\u00eb. Pas rreth 3 muajve filluam t\u00eb hedhim komponentin e par\u00eb. Pas 6 muajve, ne u ndam\u00eb plot\u00ebsisht nga gjith\u00e7ka tjet\u00ebr. Na mbeti vet\u00ebm ClickHouse.<\/p>\n<p><\/p>\n<p><em>Igor, faleminderit shum\u00eb p\u00ebr prezantimin. M\u00eb p\u00eblqeu shum\u00eb funksionaliteti i nd\u00ebrtimit t\u00eb rrug\u00ebve n\u00ebp\u00ebr harta. A planifikohet integrimi me Yandex.Maps dhe ve\u00e7an\u00ebrisht me harta t\u00eb personalizuara t\u00eb Yandex?<\/em><\/p>\n<p><\/p>\n<p>Provoja t\u00eb integrohem n\u00eb vend t\u00eb Google map, por nuk e gjeta tem\u00ebn e err\u00ebt n\u00eb Yandex.Maps. Nuk e tregova nj\u00eb pjes\u00eb. Do t\u00eb kthehem p\u00ebr t\u00eb shtuar. <\/p>\n<p><\/p>\n<p>Slide \u2013 Google map. A there is a command 'DRAW_GMAPS' that draws the map. There is a command 'DRAW_YMAPS', which can render Yandex.Map. In fact, under this command, there is Javascript, meaning that the data you get from ClickHouse can be sent to the Javascript you write here. And you have an area to render it out. Any chart can be drawn, meaning any chart, map, or you can draw your own component. I used another library for drawing the charts before this.<\/p>\n<p><\/p>\n<p><em>So there is a tool for customizing the display functionality?<\/em><\/p>\n<p><\/p>\n<p>Any. You can take and repaint these points, making them not red, but blue, green.<\/p>\n<p><\/p>\n<p><em>Thank you for the presentation! You had a slide that presented alternative tools for queries<\/em> <em>ClickHouse<\/em> <em>for building dashboards, analytical reports. I understood that at the moment when you started working with<\/em> <em>ClickHouse, p\u00ebr k\u00ebto mjete nuk jan\u00eb shkruar adaptuesit. Dhe m\u00eb intereson pse vendos\u00ebt t\u00eb b\u00ebni mjetin tuaj, n\u00eb vend q\u00eb t\u00eb shkruani nj\u00eb adaptues p\u00ebr ndonj\u00eb mjet t\u00eb gatsh\u00ebm? Mendoj se sa e shpejt\u00eb \u00ebsht\u00eb t\u00eb p\u00ebrshtas\u00ebsh redaktorin e testit. Pse vendos\u00ebt t\u00eb b\u00ebni kaq shum\u00eb pun\u00eb?<\/em><\/p>\n<p><\/p>\n<p>K\u00ebtu \u00ebsht\u00eb nj\u00eb moment interesant - \u00e7\u00ebshtja \u00ebsht\u00eb se un\u00eb jam drejtor teknik, jo shkenc\u00ebtar t\u00eb dh\u00ebnash. N\u00eb at\u00eb koh\u00eb, kur filluam t\u00eb implementonim Druid, koha ime e planit kishte rreth 50% detyrash - le t\u00eb llogarisim k\u00ebt\u00eb ose le t\u00eb llogarisim k\u00ebt\u00eb ose t\u00eb analizojm\u00eb k\u00ebt\u00eb. Dhe rezultoi se ne implementuam ClickHouse. Fillova t\u00eb nd\u00ebrtoj shpejt, t\u00eb llogaris, dhe mbylla shpejt planin tim. Dhe n\u00eb at\u00eb koh\u00eb e kuptova q\u00eb m\u00eb mungonin njohurit\u00eb p\u00ebr Shkenc\u00ebn e t\u00eb Dh\u00ebnave, p\u00ebr vizualizimin e t\u00eb dh\u00ebnave. Tabix \u00ebsht\u00eb nj\u00eb lloj detyre sht\u00ebpie p\u00ebr studimin e vizualizimit t\u00eb t\u00eb dh\u00ebnave. Kam par\u00eb si t\u00eb shtoj Zeppelin. Kam nj\u00eb antipati t\u00eb leht\u00eb p\u00ebr programimin e tij. Shikova si t\u00eb shtoj Redash, por m\u00eb mungonte nj\u00eb redaktor i mir\u00eb atje. Edhe SuperSet \u00ebsht\u00eb shkruar n\u00eb at\u00eb gjuh\u00eb q\u00eb nuk e dua shum\u00eb. Prandaj vendosa t\u00eb b\u00ebj nj\u00eb bi\u00e7iklet\u00eb, dhe ja \u00e7far\u00eb t\u00eb arrit\u00ebm.<\/p>\n<p><\/p>\n<p><em>Igor, pranon ti k\u00ebrkes\u00ebn p\u00ebr t\u00ebrheqje?<\/em><\/p>\n<p><\/p>\n<p>Po.<\/p>\n<p><\/p>\n<p><em>Faleminderit shum\u00eb p\u00ebr referatin! Dhe dy pyetje. E para \u2013 ti nuk flet shum\u00eb mir\u00eb p\u00ebr<\/em> Javascript. A ke shkruar n\u00eb Javascript t\u00eb past\u00ebr apo \u00ebsht\u00eb ndonj\u00eb framework?<\/p>\n<p><\/p>\n<p>M\u00eb mir\u00eb n\u00eb Javascript t\u00eb past\u00ebr.<\/p>\n<p><\/p>\n<p>Pra, cili framework?<\/p>\n<p><\/p>\n<p>Angular.<\/p>\n<p><\/p>\n<p><em>E kuptoj. Dhe pyetja e dyt\u00eb. A ke shqyrtuar ndonj\u00ebher\u00eb<\/em> R <em>dhe<\/em> *<strong>Shiny**<\/strong>?*<\/p>\n<p><\/p>\n<p>E kam shqyrtuar. Kam luajtur me t\u00eb. <\/p>\n<p><\/p>\n<p><em>Ishte e mundur t\u00eb shkruaje thjesht nj\u00eb adapter.<\/em><\/p>\n<p><\/p>\n<p>Po, ekziston. Duket se komuniteti e ka b\u00ebr\u00eb, por, si\u00e7 u p\u00ebrgjigja n\u00eb pyetje e m\u00ebparshme, d\u00ebshiroja ta provoj vet\u00eb.<\/p>\n<p><\/p>\n<p>*Jo, p\u00ebr sa i p\u00ebrket vizualizimit, ekziston.<\/p>\n<p><\/p>\n<p>Ti thua se ka nj\u00eb gj\u00eb q\u00eb do ta vizualizoj\u00eb grafikun p\u00ebr ty. Hapa nj\u00eb lib\u00ebr p\u00ebr vizualizimin e t\u00eb dh\u00ebnave. Dhe mendova: \u00abLe t\u00eb p\u00ebrpiqem t'i vizualizoj k\u00ebto t\u00eb dh\u00ebna. Do ta shkruaj vet\u00eb q\u00eb ai t\u00eb nd\u00ebrtoj\u00eb t\u00eb dh\u00ebnat\u00bb. Dhe fillova t\u00eb kuptoj m\u00eb mir\u00eb teknologjin\u00eb e paraqitjes s\u00eb t\u00eb dh\u00ebnave. N\u00ebse do t\u00eb merrja nj\u00eb komponent t\u00eb gatsh\u00ebm, do t\u00eb m\u00ebsja m\u00eb keq si ta p\u00ebrdorja, pra, pik\u00ebrisht vizualizimin. Por k\u00ebshtu \u2013 po, m\u00eb p\u00eblqeu R, por akoma nuk kam lexuar librin \u00abR p\u00ebr fillestar\u00ebt.\u00bb <\/p>\n<p><\/p>\n<p><em>Faleminderit!<\/em><\/p>\n<p><\/p>\n<p><em>Nj\u00eb pyetje e thjesht\u00eb. A ekzistojn\u00eb mund\u00ebsi p\u00ebr t\u00eb eksportuar shpejt nj\u00eb tabel\u00eb, grafikun?<\/em><\/p>\n<p><\/p>\n<p>Mund t\u00eb eksportohet n\u00eb CSV, n\u00eb Excel.<\/p>\n<p><\/p>\n<p><em>Ajo t'i jepni nj\u00eb tabel\u00eb t\u00eb gatshme, nj\u00eb graf t\u00eb p\u00ebrgatitur? P\u00ebr shembull, p\u00ebr ta treguar drejtuesve.<\/em><\/p>\n<p><\/p>\n<p>Ka nj\u00eb buton \u00abShkarko\u00bb dhe ka nj\u00eb buton \u00abShkarko grafikun n\u00eb png, n\u00eb jpg\u00bb.<\/p>\n<p><\/p>\n<p><em>Faleminderit!<\/em><\/p>\n<p><\/p>\n<p>P.S. Udh\u00ebzues i shkurt\u00ebr p\u00ebr instalimin e tabix.<\/p>\n<p><\/p>\n<ul>\n<li>Shkarko <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/smi2\/tabix.ui\/releases\">l\u00ebshimi i fundit<\/a><\/noindex><\/li>\n<li>Zb\u00ebrthe, kopjo direktorin\u00eb <code>nd\u00ebrto<\/code> n\u00eb rrug\u00ebn e nginx root_path<\/li>\n<li>Konfiguro nginx<\/li>\n<\/ul>\n<p>Burimi: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/491308\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u041f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u044e \u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u0442\u044c\u0441\u044f \u0441 \u0440\u0430\u0441\u0448\u0438\u0444\u0440\u043e\u0432\u043a\u043e\u0439 \u0434\u043e\u043a\u043b\u0430\u0434\u0430 2017 \u0433\u043e\u0434\u0430 \u0418\u0433\u043e\u0440\u044c \u0421\u0442\u0440\u044b\u0445\u0430\u0440\u044c \u00abClickHouse \u2013 \u0432\u0438\u0437\u0443\u0430\u043b\u044c\u043d\u043e \u0431\u044b\u0441\u0442\u0440\u044b\u0439 \u0438 \u043d\u0430\u0433\u043b\u044f\u0434\u043d\u044b\u0439 \u0430\u043d\u0430\u043b\u0438\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 Tabix\u00bb. \u0412\u0435\u0431-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0434\u043b\u044f ClickHouse \u0432 \u043f\u0440\u043e\u0435\u043a\u0442\u0435 Tabix. \u041e\u0441\u043d\u043e\u0432\u043d\u044b\u0435 \u0432\u043e\u0437\u043c\u043e\u0436\u043d\u043e\u0441\u0442\u0438: \u0420\u0430\u0431\u043e\u0442\u0430\u0435\u0442 \u0441 ClickHouse \u043d\u0430\u043f\u0440\u044f\u043c\u0443\u044e \u0438\u0437 \u0431\u0440\u0430\u0443\u0437\u0435\u0440\u0430, \u0431\u0435\u0437 \u043d\u0435\u043e\u0431\u0445\u043e\u0434\u0438\u043c\u043e\u0441\u0442\u0438 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043a\u0438 \u0434\u043e\u043f\u043e\u043b\u043d\u0438\u0442\u0435\u043b\u044c\u043d\u043e\u0433\u043e \u041f\u041e; \u0420\u0435\u0434\u0430\u043a\u0442\u043e\u0440 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432 \u0441 \u043f\u043e\u0434\u0441\u0432\u0435\u0442\u043a\u043e\u0439 \u0441\u0438\u043d\u0442\u0430\u043a\u0441\u0438\u0441\u0430; \u0410\u0432\u0442\u043e\u0434\u043e\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435 \u043a\u043e\u043c\u0430\u043d\u0434; \u0418\u043d\u0441\u0442\u0440\u0443\u043c\u0435\u043d\u0442\u044b \u0433\u0440\u0430\u0444\u0438\u0447\u0435\u0441\u043a\u043e\u0433\u043e \u0430\u043d\u0430\u043b\u0438\u0437\u0430 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u044f \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u0432; \u0426\u0432\u0435\u0442\u043e\u0432\u044b\u0435 \u0441\u0445\u0435\u043c\u044b \u043d\u0430 \u0432\u044b\u0431\u043e\u0440. \u042f [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":73359,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-73358","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u041f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u044e \u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u0442\u044c\u0441\u044f \u0441 \u0440\u0430\u0441\u0448\u0438\u0444\u0440\u043e\u0432\u043a\u043e\u0439 \u0434\u043e\u043a\u043b\u0430\u0434\u0430 2017 \u0433\u043e\u0434\u0430 \u0418\u0433\u043e\u0440\u044c \u0421\u0442\u0440\u044b\u0445\u0430\u0440\u044c \u00abClickHouse \u2013 \u0432\u0438\u0437\u0443\u0430\u043b\u044c\u043d\u043e \u0431\u044b\u0441\u0442\u0440\u044b\u0439 \u0438 \u043d\u0430\u0433\u043b\u044f\u0434\u043d\u044b\u0439 \u0430\u043d\u0430\u043b\u0438\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 Tabix\u00bb. \u0412\u0435\u0431-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0434\u043b\u044f ClickHouse \u0432 \u043f\u0440\u043e\u0435\u043a\u0442\u0435 Tabix..\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/clickhouse-vizualno-bystryj-i-naglyadnyj-analiz-dannyh-v-tabix-igor-stryhar\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47ClickHouse \u2013 \u0432\u0438\u0437\u0443\u0430\u043b\u044c\u043d\u043e \u0431\u044b\u0441\u0442\u0440\u044b\u0439 \u0438 \u043d\u0430\u0433\u043b\u044f\u0434\u043d\u044b\u0439 \u0430\u043d\u0430\u043b\u0438\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 Tabix. \u0418\u0433\u043e\u0440\u044c \u0421\u0442\u0440\u044b\u0445\u0430\u0440\u044c | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u041f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u044e \u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u0442\u044c\u0441\u044f \u0441 \u0440\u0430\u0441\u0448\u0438\u0444\u0440\u043e\u0432\u043a\u043e\u0439 \u0434\u043e\u043a\u043b\u0430\u0434\u0430 2017 \u0433\u043e\u0434\u0430 \u0418\u0433\u043e\u0440\u044c \u0421\u0442\u0440\u044b\u0445\u0430\u0440\u044c \u00abClickHouse \u2013 \u0432\u0438\u0437\u0443\u0430\u043b\u044c\u043d\u043e \u0431\u044b\u0441\u0442\u0440\u044b\u0439 \u0438 \u043d\u0430\u0433\u043b\u044f\u0434\u043d\u044b\u0439 \u0430\u043d\u0430\u043b\u0438\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 Tabix\u00bb. \u0412\u0435\u0431-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0434\u043b\u044f ClickHouse \u0432 \u043f\u0440\u043e\u0435\u043a\u0442\u0435 Tabix..\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/clickhouse-vizualno-bystryj-i-naglyadnyj-analiz-dannyh-v-tabix-igor-stryhar\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-03-09T05:42:14+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-03-09T05:42:14+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47ClickHouse \u2013 analiza e shpejt\u00eb dhe vizuale e t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhari | ProHoster","description":"Ju ofroj t\u00eb shqyrtoni interpretimin e raportit t\u00eb vitit 2017 nga Igor Strykhary \u00abClickHouse \u2013 analiz\u00eb e shpejt\u00eb dhe vizuale e t\u00eb dh\u00ebnave n\u00eb Tabix\u00bb. Nd\u00ebrfaqja n\u00eb ueb p\u00ebr ClickHouse n\u00eb projektin Tabix.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/clickhouse-vizualno-bystryj-i-naglyadnyj-analiz-dannyh-v-tabix-igor-stryhar","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47ClickHouse \u2013 \u0432\u0438\u0437\u0443\u0430\u043b\u044c\u043d\u043e \u0431\u044b\u0441\u0442\u0440\u044b\u0439 \u0438 \u043d\u0430\u0433\u043b\u044f\u0434\u043d\u044b\u0439 \u0430\u043d\u0430\u043b\u0438\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 Tabix. \u0418\u0433\u043e\u0440\u044c \u0421\u0442\u0440\u044b\u0445\u0430\u0440\u044c | ProHoster","og:description":"\u041f\u0440\u0435\u0434\u043b\u0430\u0433\u0430\u044e \u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u0442\u044c\u0441\u044f \u0441 \u0440\u0430\u0441\u0448\u0438\u0444\u0440\u043e\u0432\u043a\u043e\u0439 \u0434\u043e\u043a\u043b\u0430\u0434\u0430 2017 \u0433\u043e\u0434\u0430 \u0418\u0433\u043e\u0440\u044c \u0421\u0442\u0440\u044b\u0445\u0430\u0440\u044c \u00abClickHouse \u2013 \u0432\u0438\u0437\u0443\u0430\u043b\u044c\u043d\u043e \u0431\u044b\u0441\u0442\u0440\u044b\u0439 \u0438 \u043d\u0430\u0433\u043b\u044f\u0434\u043d\u044b\u0439 \u0430\u043d\u0430\u043b\u0438\u0437 \u0434\u0430\u043d\u043d\u044b\u0445 \u0432 Tabix\u00bb. \u0412\u0435\u0431-\u0438\u043d\u0442\u0435\u0440\u0444\u0435\u0439\u0441 \u0434\u043b\u044f ClickHouse \u0432 \u043f\u0440\u043e\u0435\u043a\u0442\u0435 Tabix..","og:url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/clickhouse-vizualno-bystryj-i-naglyadnyj-analiz-dannyh-v-tabix-igor-stryhar","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-03-09T05:42:14+00:00","article:modified_time":"2020-03-09T05:42:14+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"73358","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 18:34:26","updated":"2022-09-28 10:01:24","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/73358","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=73358"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/73358\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/73359"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=73358"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=73358"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=73358"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}