{"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 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb t\u00eb dh\u00ebnave n\u00eb Tabix. Igor Strykhar","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><strong>Ju ofroj t\u00eb njihet me interpretimin e raportit t\u00eb vitit 2017 nga Igor Strikhar \u00abClickHouse \u2013 analiz\u00eb e shpejt\u00eb dhe e qart\u00eb vizualisht e t\u00eb dh\u00ebnave n\u00eb Tabix\u00bb.<\/strong><\/p>\n<p><\/p>\n<p>Nd\u00ebrfaqja n\u00eb internet p\u00ebr ClickHouse n\u00eb projektin Tabix.<br \/>\nKarakteristikat kryesore:<\/p>\n<p><\/p>\n<ul>\n<li>Punon me ClickHouse drejtp\u00ebrdrejt nga shfletuesi, pa nevoj\u00ebn p\u00ebr instalimin e software-s\u00eb shtes\u00eb;<\/li>\n<li>Redaktori i pyetjeve me ndri\u00e7im sintaksor;<\/li>\n<li>Autopopullimi i komandave;<\/li>\n<li>Mjetet e analiz\u00ebs grafike t\u00eb ekzekutimit t\u00eb pyetjeve;<\/li>\n<li>Paletat e ngjyrave p\u00ebrzgjedhje.<br \/>\n<img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 n\u00eb SMI2. Ne jemi nj\u00eb agregator lajmesh p\u00ebr shk\u00ebmbimin e lajmeve. Ruajm\u00eb shum\u00eb t\u00eb dh\u00ebna q\u00eb i marim 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 n\u00eb lajme.<\/li>\n<li>Shfaqjet e lajmeve n\u00eb agregator.<\/li>\n<li>Shfaqjet e banderoleve n\u00eb rrjetin ton\u00eb.<\/li>\n<li>Dhe regjistrojm\u00eb ngjarjet nga num\u00ebruesi yn\u00eb t\u00eb brendsh\u00ebm, i ngjash\u00ebm me Yandex.Metrika. Kjo \u00ebsht\u00eb mikroanalitika jon\u00eb. <\/li>\n<\/ul>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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>Pat\u00ebm nj\u00eb jet\u00eb t\u00eb trazuar para ClickHouse. Kemi vuajtur shum\u00eb duke u p\u00ebrpjekur t\u00eb ruanim k\u00ebto t\u00eb dh\u00ebna ndokund dhe t'i analizojm\u00eb si\u00e7 duhet.<\/p>\n<p><\/p>\n<p><strong>Jeta para ClickHouse \u2013 infiniDB<\/strong><\/p>\n<p><\/p>\n<p>E para q\u00eb pat\u00ebm, ishte infiniDB. Ajo q\u00ebndroi p\u00ebr 4 vjet. E filluam me v\u00ebshtir\u00ebsi. <\/p>\n<p><\/p>\n<ul>\n<li>Ajo nuk mb\u00ebshteste klasterizimin ose sharding-un. Asnj\u00eb ve\u00e7ori e till\u00eb e zgjuar nuk ishte e aktivizuar nga kutia. <\/li>\n<li>Sfondi kishte probleme me ngarkimin e t\u00eb dh\u00ebnave. Vet\u00ebm nj\u00eb utilitar konsol\u00eb specifik, i cili mund t\u00eb ngarkonte vet\u00ebm skedar\u00ebt CSV dhe vet\u00ebm n\u00eb m\u00ebnyr\u00eb shum\u00eb t\u00eb paqart\u00eb. <\/li>\n<li>Baza e t\u00eb dh\u00ebnave ishte nj\u00ebp\u00ebrdor\u00ebshe. Mund t\u00eb shkruaje ose t\u00eb lexoje. Por ajo lejonte p\u00ebrpunimin e nj\u00eb sasi t\u00eb madhe t\u00eb dh\u00ebnash. <\/li>\n<li>Dhe kishte nj\u00eb zgjidhje interesante. \u00c7do nat\u00eb, duhej t\u00eb rihapej serveri, ndryshe ai nuk punonte. <\/li>\n<\/ul>\n<p><\/p>\n<p>Ajo punoi deri n\u00eb fund t\u00eb vitit 2016, kur kaluam plot\u00ebsisht n\u00eb ClickHouse.<\/p>\n<p><\/p>\n<p><strong>Jeta para ClickHouse \u2013 Cassandra<\/strong><\/p>\n<p><\/p>\n<p>Pasi infiniDB ishte nj\u00ebp\u00ebrdor\u00ebshe, ne vendos\u00ebm q\u00eb na duhej nj\u00eb baz\u00eb t\u00eb dh\u00ebnash shum\u00ebp\u00ebrdor\u00ebse, n\u00eb t\u00eb cil\u00ebn mund t\u00eb shkruanim shum\u00eb rrjedha n\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb.<\/p>\n<p><\/p>\n<p>Provuam shum\u00eb gj\u00ebra interesante. Pastaj vendos\u00ebm t\u00eb provonim Cassandra. Me Cassandra kishim gjith\u00e7ka n\u00eb rregull. 10,000 pyetje n\u00eb sekond\u00eb p\u00ebr shkak. 2,000 pyetje p\u00ebr lexim. <\/p>\n<p><\/p>\n<p>Por ajo kishte gjithashtu interesat e veta. Nj\u00eb her\u00eb n\u00eb muaj ose nj\u00eb her\u00eb n\u00eb dy muaj, ndodhte t\u00eb kishte nj\u00eb desinkronizim t\u00eb baz\u00ebs s\u00eb t\u00eb dh\u00ebnave. Dhe duhej t\u00eb zgjoheshim dhe t\u00eb vraponim p\u00ebr ta rregulluar Cassandra. Restartonim server\u00ebt nj\u00eb p\u00ebr nj\u00eb. Dhe 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, ne kuptuam se na duhej t\u00eb shkruanim edhe m\u00eb shum\u00eb t\u00eb dh\u00ebna. N\u00eb vitin 2016 filluam t\u00eb shikonim Druid. <\/p>\n<p><\/p>\n<p>Druid \u00ebsht\u00eb nj\u00eb baz\u00eb e hapur, e shkruar n\u00eb Java. Jasht\u00ebzakonisht specifike. Dhe ishte e p\u00ebrshtatshme p\u00ebr clickstream, kur na duhej t\u00eb ruanim nj\u00eb flux ngjarjesh dhe pastaj t\u00eb b\u00ebnim agregimin e tyre ose t\u00eb b\u00ebnim raporte analitike.<\/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 \u00ebsht\u00eb shum\u00eb e v\u00ebshtir\u00eb p\u00ebr tu vendosur. Kjo \u00ebsht\u00eb nj\u00eb v\u00ebshtir\u00ebsi infrastrukturore. P\u00ebr ta vendosur, na duhej t\u00eb vendosnim shum\u00eb pajisje. Dhe \u00e7do pajisje ishte p\u00ebrgjegj\u00ebse p\u00ebr nj\u00eb rol t\u00eb ve\u00e7ant\u00eb. <\/p>\n<p><\/p>\n<p>P\u00ebr t\u00eb ngarkuar t\u00eb dh\u00ebnat n\u00eb t\u00eb, ishte e nevojshme t\u00eb aplikonim ndonj\u00eb far\u00eb magjie. Ekziston nj\u00eb projekt OpenSource \u2013 Tranquility, i cili n\u00eb flux humbiste t\u00eb dh\u00ebnat tona. Kur ngarkonim t\u00eb dh\u00ebna n\u00eb t\u00eb, ai i humbiste. <\/p>\n<p><\/p>\n<p>Por nj\u00ebfar\u00eb m\u00ebnyre filluam ta implementonim. Ishim si shpez\u00eb t\u00eb cil\u00ebt po l\u00ebndoheshin, por vazhdonin t\u00eb hanin kaktus, filluam ta implementonim. Na duhej rreth nj\u00eb muaj p\u00ebr t\u00eb p\u00ebrgatitur t\u00eb gjith\u00eb infrastruktur\u00ebn p\u00ebr t\u00eb. Dometh\u00ebn\u00eb, t\u00eb porositej servera, t\u00eb konfiguroheshin rolet, t\u00eb realizohej automatizimi i plot\u00eb i vendosjes. Dometh\u00ebn\u00eb, n\u00eb rast r\u00ebnia e klastra, q\u00eb t\u00eb vendos\u00ebsh automatikisht nj\u00eb klas\u00ebr t\u00eb dyt\u00eb. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 k\u00ebtu ndodhi nj\u00eb mrekulli. Un\u00eb isha n\u00eb pushim, dhe koleg\u00ebt e mi m\u00eb d\u00ebrguan nj\u00eb lidhje n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/yandex\/blog\/303282\/\">habr<\/a><\/noindex>, ku thuhej se Yandex vendosi t\u00eb hap\u00eb ClickHouse. I thash\u00eb q\u00eb le t\u00eb provojm\u00eb.<\/p>\n<p><\/p>\n<p>Dhe p\u00ebr vet\u00ebm 2 dit\u00eb vendos\u00ebm nj\u00eb klas\u00ebr testues t\u00eb ClickHouse. Filluam t\u00eb ngarkonim t\u00eb dh\u00ebna n\u00eb t\u00eb. N\u00eb krahasim me infiniDB \u2013 \u00ebsht\u00eb elementar, n\u00eb krahasim me Druid \u2013 \u00ebsht\u00eb elementar. N\u00eb krahasim me Cassandra gjithashtu \u00ebsht\u00eb elementar. Sepse n\u00ebse ngarkohet t\u00eb dh\u00ebnat n\u00eb Cassandra nga php, at\u00ebher\u00eb kjo nuk \u00ebsht\u00eb elementare.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 fituam? Performanc\u00eb n\u00eb shpejt\u00ebsi. Performanc\u00eb n\u00eb ruajtjen e t\u00eb dh\u00ebnave. Dometh\u00ebn\u00eb, p\u00ebrdoret shum\u00eb m\u00eb pak hap disku. ClickHouse \u00ebsht\u00eb i shpejt\u00eb, \u00ebsht\u00eb shum\u00eb i shpejt\u00eb krahasuar me produktet e tjera. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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, ishte vet\u00ebm klienti konsol. Ne n\u00eb kompanin\u00eb ton\u00eb \u0421\u041c\u04182 vendos\u00ebm t\u00eb provojm\u00eb t\u00eb b\u00ebjm\u00eb nj\u00eb klient natyror p\u00ebr web, n\u00eb m\u00ebnyr\u00eb q\u00eb t\u00eb mund t\u00eb hapnim nj\u00eb faqe nga shfletuesi, t\u00eb shkruanim nj\u00eb k\u00ebrkes\u00eb dhe t\u00eb merrnim rezultatin, sepse filluam t\u00eb shkruanim shum\u00eb k\u00ebrkesa. T\u00eb shkruash n\u00eb konsol \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 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 rreth dimrit t\u00eb vitit t\u00eb kaluar filluan t\u00eb shfaqeshin mjete t\u00eb tjera p\u00ebr pun\u00eb 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, pra ato me t\u00eb cilat kam punuar. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 mjet i mir\u00eb, por p\u00ebr Druid. Kur implementoja Druid, e provoja SuperSet. M\u00eb p\u00eblqeu. Punon shum\u00eb shpejt p\u00ebr Druid. <\/p>\n<p><\/p>\n<p>Nuk \u00ebsht\u00eb i p\u00ebrshtatsh\u00ebm p\u00ebr ClickHouse. Pra, \u00ebsht\u00eb i p\u00ebrshtatsh\u00ebm, funksionon, por \u00ebsht\u00eb i aft\u00eb vet\u00ebm p\u00ebr t\u00eb p\u00ebrpunuar k\u00ebrkesa elementare si: SELECT event, GROUP BY event. 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 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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>Mjeti tjet\u00ebr \u00ebsht\u00eb Apache Zeppelin. Kjo \u00ebsht\u00eb nj\u00eb gj\u00eb e mir\u00eb dhe interesante. Funksionon. Mb\u00ebshtet notebook-et, dashboard-et, mb\u00ebshtet variablat. E di q\u00eb dikush nga komuniteti ClickHouse e p\u00ebrdor at\u00eb. <\/p>\n<p><\/p>\n<p>Por nuk ka mb\u00ebshtetje p\u00ebr sintaks\u00ebn e ClickHouse, pra do t'ju duhet t\u00eb shkruani k\u00ebrkesat ose n\u00eb konsol\u00eb ose diku tjet\u00ebr. Pastaj t\u00eb kontrolloni q\u00eb gjith\u00e7ka funksionon. Kjo \u00ebsht\u00eb thjesht e pak\u00ebndshme. Por mb\u00ebshtetja p\u00ebr dashboard \u00ebsht\u00eb e mir\u00eb. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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>Mjeti tjet\u00ebr \u00ebsht\u00eb Redash.IO. Redash \u00ebsht\u00eb i hostuar n\u00eb internet. Pra, n\u00eb krahasim me mjetet e m\u00ebparshme, nuk ka nevoj\u00eb ta instaloni. Dhe ky \u00ebsht\u00eb nj\u00eb dashboard me mund\u00ebsin\u00eb e konsolidimit t\u00eb t\u00eb dh\u00ebnave nga Burime t\u00eb Diferencuara. Pra, mund t\u00eb shkarkoni nga ClickHouse, nga MySQL, nga PostgreSQL dhe nga bazat e tjera t\u00eb t\u00eb dh\u00ebnave. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 shfaq mb\u00ebshtetja n\u00eb Grafana. Kur krijoni raportet n\u00eb Grafana, le t\u00eb themi, p\u00ebr gjendjen e pajisjeve tuaja ose p\u00ebr disa metrika, tani mund t\u00eb krijoni nj\u00eb grafik t\u00eb till\u00eb ose ndonj\u00eb panel nga t\u00eb dh\u00ebnat e ClickHouse drejtp\u00ebrdrejt. Kjo \u00ebsht\u00eb shum\u00eb e p\u00ebrshtatshme, dhe ne e p\u00ebrdorim te ne. Kjo lejon t\u00eb gjejm\u00eb anomali. Pra, n\u00ebse ndodhin gj\u00ebra dhe ndonj\u00eb pajisje d\u00ebshton ose ngarkohet, mund t\u00eb shihni shkakun, n\u00ebse k\u00ebto t\u00eb dh\u00ebna kan\u00eb arritur n\u00eb ClickHouse. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 ishte shum\u00eb e pap\u00ebrshtatshme t\u00eb shkruaja n\u00eb k\u00ebto mjete ose n\u00eb konsol\u00eb. Dhe vendosa t\u00eb punoj mbi nd\u00ebrfaqen ton\u00eb t\u00eb par\u00eb. Dhe munda iden\u00eb nga EventSQL, SeperSet, Zeppelin.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 doja? Doja t\u00eb merrja grafik\u00eb, nj\u00eb redaktor t\u00eb p\u00ebrmir\u00ebsuar, 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 punoni me fjalor\u00ebt, sepse duhet t\u00eb mbani mend formatin e vlerave t\u00eb ruajtura, pra n\u00ebse \u00ebsht\u00eb num\u00ebr ose varg, etj. Dhe meqen\u00ebse ne shpesh p\u00ebrdorim fjalor\u00ebt n\u00eb variacione t\u00eb ndryshme, ishte mjaft e v\u00ebshtir\u00eb t\u00eb shkruaja k\u00ebrkesa.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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>Kalonin 3 muaj nga lansimi i versionit ton\u00eb t\u00eb par\u00eb. Kam b\u00ebr\u00eb rreth 330 komitete n\u00eb deg\u00ebn e mbyllur dhe rezultati ishte Tabix.<\/p>\n<p><\/p>\n<p>Ndryshe nga versioni i m\u00ebparsh\u00ebm, i cili quhej ClickHouse-Frontend, kam vendosur ta riformuloj at\u00eb n\u00eb nj\u00eb em\u00ebr m\u00eb t\u00eb thjesht\u00eb. Dhe tani quhet Tabix.<\/p>\n<p><\/p>\n<p>\u00c7far\u00eb ka r\u00ebn\u00eb?<\/p>\n<p><\/p>\n<p>Vizaton grafik\u00eb. Mb\u00ebshtet sintaks\u00ebn SQL t\u00eb ClickHouse. Sugjeron p\u00ebr funksionet dhe ka shum\u00eb aft\u00ebsi interesante.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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\u00ebshtu duket skema e p\u00ebrgjithshme e Tabix. Majtas \u00ebsht\u00eb paraqitur nj\u00eb pem\u00eb. N\u00eb qend\u00ebr \u2013 \u00ebsht\u00eb redaktori i k\u00ebrkes\u00ebs. Dhe posht\u00eb \u2013 \u00ebsht\u00eb rezultati i k\u00ebsaj k\u00ebrkese.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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>Tani do t\u00eb tregoj se si funksionon redaktori i k\u00ebrkes\u00ebs. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 autokompleti mbi tabel\u00ebn dhe sugjeron, p\u00ebrkat\u00ebsisht, autokompletin mbi fushat. Dhe sugjerimet p\u00ebr funksionet. N\u00ebse shtypni ctrl dhe pastaj enter, k\u00ebrkesa do t\u00eb ekzekutohet ose do t\u00eb d\u00ebshtoj\u00eb me 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 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 kam th\u00ebn\u00eb m\u00eb par\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 realizojm\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\u00ebsi dhe gjat\u00ebsi. Nd\u00ebrsa n\u00eb baz\u00eb ruajm\u00eb vet\u00ebm identifikuesin e qytetit. K\u00ebshtu, ne e kompresojm\u00eb t\u00eb dh\u00ebnat shum\u00eb.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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, duke u dukur si nj\u00eb gj\u00eb e thjesht\u00eb, n\u00eb ClickHouse ndihmon shum\u00eb interessant. Pasi ClickHouse mb\u00ebshtet vet\u00ebm join t\u00eb thella, k\u00ebrkesa rritet mjaft posht\u00eb dhe gjer\u00eb. Dhe kur hapet nj\u00eb kllap\u00eb dhe vjen nj\u00eb shprehje e gjat\u00eb, nj\u00eb gj\u00eb mjaft e thjesht\u00eb si t\u00ebrheqja e k\u00ebrkes\u00ebs ndihmon p\u00ebr t\u00eb punuar m\u00eb leht\u00eb me k\u00ebrkes\u00ebn e vet. Sepse kur k\u00ebrkesa ka 200-300 rreshta dhe \u00ebsht\u00eb shum\u00eb e gjer\u00eb, t\u00ebrheqja e k\u00ebrkes\u00ebs ndihmon shum\u00eb p\u00ebr t\u00eb gjetur ndonj\u00eb vend apo p\u00ebr ta lokalizuar.<\/p>\n<p><\/p>\n<p>Pem\u00eb objektesh, shum\u00ebk\u00ebrkesa dhe skedar\u00ebt (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 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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, skedar\u00ebt. Majtas \u2013 \u00ebsht\u00eb pema, lart mund t\u00eb krijoni disa skedar\u00eb. Skedar\u00ebt jan\u00eb si nj\u00eb hap\u00ebsir\u00eb pune. Mund t\u00eb krijoni disa skedar\u00eb dhe secil\u00ebn ta emroni ndryshe. Kjo \u00ebsht\u00eb si nj\u00eb minisit\u00ebm p\u00ebr nd\u00ebrtimin e raporteve.<\/p>\n<p><\/p>\n<p>Skedar\u00ebt ruhen automatikisht. N\u00ebse e rinisni shfletuesin tuaj ose e mbyllni, ose hapni Tabix, gjith\u00e7ka do t\u00eb ruhet.<\/p>\n<p><\/p>\n<p>Kombinimi i \u00e7el\u00ebsave \u2013 komod (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 kombinime \u00e7el\u00ebsash dhe ka mjaft prej tyre. Disa nga ato i kam paraqitur k\u00ebtu si shembuj. Kjo \u00ebsht\u00eb p\u00ebr nd\u00ebrrimin e skedar\u00ebve, 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 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 si t\u00eb punoni me rezultatin. D\u00ebrgoni k\u00ebrkes\u00ebn. K\u00ebtu vizatoj sin, cos dhe tg. Mund t\u00eb theksoni rezultatin, dometh\u00ebn\u00eb, t\u00eb vizatoni nj\u00eb hart\u00eb tipike mbi kolon\u00ebn. Mund t\u00eb theksoni vlerat pozitive ose negative. Ose thjesht t\u00eb ngjyrosni ndonj\u00eb element t\u00eb ve\u00e7ant\u00eb t\u00eb tabel\u00ebs. Kjo \u00ebsht\u00eb e dobishme kur tabela \u00ebsht\u00eb shum\u00eb e madhe dhe duhet t\u00eb gjejm\u00eb ndonj\u00eb anomali me sy. Kur k\u00ebrkoja anomali, theksoja disa rreshta, disa elemente me ngjyr\u00eb t\u00eb gjelb\u00ebr ose t\u00eb kuqe.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 atje. P\u00ebr shembull, si t\u00eb kopjosh n\u00eb Redmine Markdown. N\u00ebse nevojitet t\u00eb kopjoni rezultatin diku, kjo \u00ebsht\u00eb shum\u00eb e dobishme. Mund thjesht t\u00eb seleksiononi nj\u00eb zon\u00eb, t\u00eb thoni \u2018Kopjoni n\u00eb Redmine\u2019 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 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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, kjo \u00ebsht\u00eb optimizimi i k\u00ebrkesave. Nj\u00eb her\u00eb harrova t\u00eb specifikoj fush\u00ebn \u2018date\u2019. Dhe k\u00ebrkesa ime n\u00eb ClickHouse u p\u00ebrpunua jo shum\u00eb shpejt, por shpejt, dometh\u00ebn\u00eb, p\u00ebr m\u00eb pak se nj\u00eb sekond\u00eb. Kur pash\u00eb sa shum\u00eb rreshta kalonte, m\u00eb friksoi. Ne nuk shkruajm\u00eb kaq shum\u00eb rreshta n\u00eb k\u00ebt\u00eb tabel\u00eb brenda nj\u00eb dite. Nisa t\u00eb analizoj k\u00ebrkes\u00ebn dhe pash\u00eb q\u00eb kisha humbur dat\u00ebn n\u00eb nj\u00eb vend. Dometh\u00ebn\u00eb, harrova t\u00eb specifikoj q\u00eb m\u00eb nevojiten 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 \u2018Stats\u2019, ku ruhet e gjith\u00eb historia e k\u00ebrkesave t\u00eb d\u00ebrguara, dometh\u00ebn\u00eb atje mund t\u00eb shihni sa rreshta ishin lexuar nga kjo k\u00ebrkes\u00eb dhe sa koh\u00eb zgjati ajo. Kjo lejon optimizimin. <\/p>\n<p><\/p>\n<p>Mund t\u00eb nd\u00ebrtosh nj\u00eb tabel\u00eb p\u00ebrmbledh\u00ebse mbi rezultatin e k\u00ebrkes\u00ebs. Keni d\u00ebrguar nj\u00eb k\u00ebrkes\u00eb n\u00eb ClickHouse, keni marr\u00eb disa t\u00eb dh\u00ebna. Dhe m\u00eb pas k\u00ebto t\u00eb dh\u00ebna mund t'i t\u00ebrheqni me miun dhe t\u00eb nd\u00ebrtoni ndonj\u00eb tabel\u00eb p\u00ebrmbledh\u00ebse.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 interesante tjet\u00ebr \u00ebsht\u00eb nd\u00ebrtimi i grafik\u00ebve. Supozoni q\u00eb kemi nj\u00eb k\u00ebrkes\u00eb t\u00eb till\u00eb: p\u00ebr sin, cos nga 0 deri n\u00eb 299. Dhe p\u00ebr ta vizatuar, duhet t\u00eb zgjidhni sked\u00ebn \u2018Draw\u2019 dhe do t\u00eb merrni grafikun me sin dhe cos tuaj. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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>Mund ta ndajm\u00eb k\u00ebt\u00eb n\u00eb osi t\u00eb ndryshme, dometh\u00ebn\u00eb, mund t\u00eb vizatojm\u00eb nj\u00ebkoh\u00ebsisht dy grafik\u00eb af\u00ebr nj\u00ebri-tjetrit. T\u00eb shkruajm\u00eb nj\u00eb komand\u00eb dhe nj\u00eb komand\u00eb tjet\u00ebr. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 vizatojm\u00eb histograma.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 ndajm\u00eb k\u00ebt\u00eb n\u00eb nj\u00eb matric\u00eb grafik\u00ebsh.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 nd\u00ebrtojm\u00eb nj\u00eb hart\u00eb termike. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 nd\u00ebrtojm\u00eb nj\u00eb kalendar termik. P\u00ebr m\u00eb tep\u00ebr, \u00ebsht\u00eb nj\u00eb gj\u00eb shum\u00eb e dobishme kur nevojitet t\u00eb analizoni anomali p\u00ebr nj\u00eb vit, dometh\u00ebn\u00eb, t\u00eb gjeni ose shp\u00ebrthime ose r\u00ebnie. Kjo vizualizim t\u00eb dh\u00ebnash m\u00eb ndihmoi n\u00eb k\u00ebt\u00eb. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 anomali t\u00eb ndryshme. \u00cbsht\u00eb shum\u00eb i p\u00ebrshtatsh\u00ebm. E rekomandoj p\u00ebr k\u00ebrkimin e tyre.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 keni n\u00eb baz\u00ebn e t\u00eb dh\u00ebnave gjer\u00ebsin\u00eb, gjat\u00ebsi dhe, p\u00ebr shembull, destinacionin, n\u00ebse keni, p\u00ebr shembull, transport t\u00eb automjeteve ose aeroplan\u00ebve n\u00eb fluturim, mund t\u00eb vizatoni rrug\u00ebt e destinacioneve. Aty mund t\u00eb vendosni gjithashtu shpejt\u00ebsin\u00eb, madh\u00ebsin\u00eb e objekteve n\u00eb t\u00eb cilat ata fluturojn\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, pa detaje.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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 keni gjer\u00ebsin\u00eb dhe gjat\u00ebsi, mund t\u00eb vizatoni rezultatin n\u00eb Google map, por pa mb\u00ebshtetje p\u00ebr aeroplan\u00ebt.<\/p>\n<p><\/p>\n<p>Ne diskutuan funksionet kryesore t\u00eb pun\u00ebs me rezultatet, me k\u00ebrkesat n\u00eb Tabix. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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>Tjetra, \u00ebsht\u00eb analiza e serverit tuaj ClickHouse. Ka nj\u00eb seksion t\u00eb ve\u00e7ant\u00eb \"Metrika\", ku mund t\u00eb shikoni gjat\u00ebsin\u00eb e t\u00eb dh\u00ebnave t\u00eb ruajtura p\u00ebr secil\u00ebn kolon\u00eb. N\u00eb screenshot tregohet se ky fush\u00eb \"referrer\" z\u00eb rreth 730 Gb. N\u00ebse ne heqim k\u00ebt\u00eb fush\u00eb, do t\u00eb kursejm\u00eb tre sharda nga 700 GB, pra rreth 2 TB, t\u00eb cilat nuk na duhen. <\/p>\n<p><\/p>\n<p>Po ashtu, kemi nj\u00eb fush\u00eb \"request_id\", q\u00eb e ruajm\u00eb n\u00eb form\u00eb string. Por n\u00ebse fillojm\u00eb ta ruajm\u00eb n\u00eb form\u00eb numerike, do ta kompresojm\u00eb k\u00ebt\u00eb fush\u00eb shum\u00eb. <\/p>\n<p><\/p>\n<p>Gjithashtu, k\u00ebtu tregohet konfigurimi i serverit dhe lista e nodeve t\u00eb klasht\u00ebr tuaj. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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>Seksioni tjet\u00ebr \u00ebsht\u00eb metrika. Ato merren 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. Kjo nuk \u00ebsht\u00eb nj\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 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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>Seksioni tjet\u00ebr \u00ebsht\u00eb proceset. N\u00ebp\u00ebrmjet tyre mund t\u00eb kuptoni \u00e7far\u00eb po ndodh n\u00eb server. T\u00eb kuptoni se \u00e7far\u00eb po ndodh atje. Kam pasur nj\u00eb k\u00ebrkes\u00eb q\u00eb merrte 200 GB \u00e7do her\u00eb p\u00ebr lexim. E pash\u00eb k\u00ebt\u00eb fal\u00eb k\u00ebtij interfejsi. E kap\u00ebm dhe e rregulluam. Dhe arrit\u00ebm rreth 30 GB, pra performanca u rrit shum\u00eb.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"ClickHouse \u2013 analiz\u00eb t\u00eb shpejt\u00eb dhe vizuale t\u00eb 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>Kam p\u00ebrfunduar. Dhe, p\u00ebr t'u th\u00ebn\u00eb t\u00eb v\u00ebrtet\u00ebn, ajo \u00ebsht\u00eb n\u00eb OpenSource, \u00ebsht\u00eb falas dhe madje nuk \u00ebsht\u00eb e nevojshme ta shkarkoni. Hidhni nj\u00eb sy 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 ndodh\u00eb m\u00eb pas? Ku do ta zhvillosh k\u00ebt\u00eb mjet?<\/em><\/p>\n<p><\/p>\n<p>M\u00eb von\u00eb do t\u00eb shfaqet dashboard-i, q\u00eb do t\u00eb thot\u00eb se ndoshta do t\u00eb shfaqet dashboard-i. Integrimi me baza t\u00eb tjera t\u00eb t\u00eb dh\u00ebnave. Un\u00eb e kam b\u00ebr\u00eb k\u00ebt\u00eb, por ende nuk e kam publikuar n\u00eb OpenSource. Kjo \u00ebsht\u00eb MySQL dhe ndoshta PostgreSQL. Pra, do t\u00eb jet\u00eb e mundur t\u00eb d\u00ebrgoni k\u00ebrkesa jo vet\u00ebm n\u00eb ClickHouse, por edhe n\u00eb mjete t\u00eb tjera nga Tabix.<\/p>\n<p><\/p>\n<p><em>K\u00ebtu shihet se \u00ebsht\u00eb b\u00ebr\u00eb nj\u00eb volum i madh pune. U krijua nj\u00eb ide mjaft e plot\u00eb. N\u00eb shfletues \u00ebsht\u00eb b\u00ebr\u00eb, duket, p\u00ebr t\u00eb p\u00ebrjashtuar zgjidhje t\u00eb shpejta n\u00eb \u00e7do os dhe p\u00ebr t\u00eb p\u00ebrmbledhur gjith\u00e7ka shpejt. Kam d\u00ebgjuar se ju jeni n\u00eb<\/em> <em>php<\/em> <em>punoni, prandaj \u00ebsht\u00eb m\u00eb e leht\u00eb t\u00eb p\u00ebrmbledh\u00ebsh n\u00eb shfletues dhe gjith\u00e7ka do t\u00eb funksionoj\u00eb. K\u00ebtij nuk ka pyetje. Pyetja \u00ebsht\u00eb kjo. Aty \u00ebsht\u00eb b\u00ebr\u00eb v\u00ebrtet shum\u00eb. Sa njer\u00ebz kan\u00eb punuar mbi k\u00ebt\u00eb? Dhe sa koh\u00eb ka zgjatur gjith\u00e7ka? Sepse mjetet p\u00ebr vet\u00eb zakonisht nuk kan\u00eb nj\u00eb funksionalitet kaq t\u00eb madh.<\/em><\/p>\n<p><\/p>\n<p>Nga vera n\u00eb vjesht\u00eb punoi nj\u00eb person nga ekipi yn\u00eb. Kjo ishte versioni i par\u00eb. Pastaj b\u00ebra 330 komit\u00eb vet\u00eb. At\u00eb q\u00eb shihni, e kemi b\u00ebr\u00eb un\u00eb dhe nj\u00eb kolegu yn\u00eb bashk\u00eb. P\u00ebr 3 muaj nga versioni i par\u00eb deri n\u00eb t\u00eb fundit, un\u00eb n\u00eb pjes\u00ebn m\u00eb t\u00eb madhe e kam b\u00ebr\u00eb. Por un\u00eb e njoh shum\u00eb dob\u00ebt Javascript-in. Ky ishte projekti im i vet\u00ebm dhe, shpresoj, t\u00eb fundit q\u00eb kam punuar n\u00eb Javascript. M\u00eb erdhi n\u00eb dor\u00eb, e shikova \u2013 oh, terror. Por doja shum\u00eb ta p\u00ebrfundonja produktin dhe kjo \u00ebsht\u00eb rezultati.<\/p>\n<p><\/p>\n<p><em>Faleminderit shum\u00eb p\u00ebr raportin! Ky \u00ebsht\u00eb nj\u00eb instrument i shk\u00eblqyer. A<\/em> <em>Tableau<\/em> <em>e keni krahasuar?<\/em><\/p>\n<p><\/p>\n<p>Faleminderit. Prandaj e quajta Tabix, sepse shkronjat e para 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 t\u00eb shitej analist\u00ebve t\u00eb brendsh\u00ebm, q\u00eb ky instrument plot\u00ebsisht do t\u00eb z\u00ebvend\u00ebsoj\u00eb<\/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>Puna e natyrshme me ClickHouse. Kam provuar Tableau, por atje nuk mund t\u00eb shkruani mb\u00ebshtetje p\u00ebr fjalor\u00eb dhe k\u00ebshtu me radh\u00eb. <strong>E di si punojn\u00eb njer\u00ebzit me Tabix. Ata shkruajn\u00eb k\u00ebrkes\u00ebn, e nxjerrin n\u00eb CSV dhe e ngarkojn\u00eb n\u00eb BI.<\/strong> Dhe aty b\u00ebjn\u00eb di\u00e7ka. Por e imagjinoj me v\u00ebshtir\u00ebsi se si b\u00ebjn\u00eb k\u00ebt\u00eb, sepse \u2013 \u00ebsht\u00eb nj\u00eb instrument grafik. Ai mund t\u00eb nxjerr\u00eb deri n\u00eb 5,000 rreshta, maksimumi 6,000 rreshta, por jo m\u00eb shum\u00eb, p\u00ebrndryshe shfletuesi nuk e p\u00ebrballon. <\/p>\n<p><\/p>\n<p><em>Pra, ka disa kufizime serioze n\u00eb volumet e t\u00eb dh\u00ebnave, apo jo?<\/em><\/p>\n<p><\/p>\n<p>Po. Nuk e imaginon se do t\u00eb d\u00ebshironit t\u00eb nxirrni 10,000 rreshta n\u00eb ekranin e shfletuesit. Pse? <\/p>\n<p><\/p>\n<p><em>N\u00ebnkuptohet se ky \u00ebsht\u00eb nj\u00eb interfeks p\u00ebr nj\u00eb shikim t\u00eb shpejt\u00eb t\u00eb t\u00eb dh\u00ebnave? T\u00eb rrotullohet pak, t\u00eb kthehet?<\/em><\/p>\n<p><\/p>\n<p>Po, shpejt t\u00eb shohim si funksionon dhe thjesht t\u00eb nd\u00ebrtojm\u00eb nj\u00eb grafik p\u00ebrmbledh\u00ebs. M\u00eb pas ta d\u00ebrgojm\u00eb diku. Ne kemi sistemin ton\u00eb t\u00eb raportimit, nga ku thjesht marr k\u00ebt\u00eb k\u00ebrkes\u00eb. E vizatoj n\u00eb Tabix dhe e d\u00ebrgoj n\u00eb raportin ton\u00eb. <\/p>\n<p><\/p>\n<p><em>Dhe nj\u00eb pyetje tjet\u00ebr. Analiza e koort\u00ebve?<\/em><\/p>\n<p><\/p>\n<p>N\u00ebse ka k\u00ebrkesa, do t'i shtojm\u00eb. <\/p>\n<p><\/p>\n<p><em>Kur sapo filluam t\u00eb p\u00ebrdorim<\/em> <em>ClickHouse, sa koh\u00eb mori implementimi<\/em> <em>ClickHouse<\/em> <em>dhe d\u00ebshira p\u00ebr ta \u00e7uar n\u00eb<\/em> <em>gjendjen e prodhimit?<\/em><\/p>\n<p><\/p>\n<p>Si\u00e7 e thash\u00eb, ne e kemi implementuar klust\u00ebrin testues n\u00eb koh\u00eb rekord. Pas dy dit\u00ebsh e kemi shpalosur. Dhe disa jav\u00eb e kemi provuar. Dhe p\u00ebr t\u00eb arritur n\u00eb prodhim na mori rreth 3 muaj. Por ne kishim ETL ton\u00eb, dmth. nj\u00eb mjet p\u00ebr regjistrimin e t\u00eb dh\u00ebnave. Ai regjistronte n\u00eb t\u00eb gjitha sistemet e mundshme. Ai di t\u00eb regjistroj\u00eb n\u00eb MongoDB, Cassandra, MySQL. Ta m\u00ebsojm\u00eb at\u00eb t\u00eb regjistroj\u00eb n\u00eb ClickHouse ishte e thjesht\u00eb. Ne kishim infrastruktur\u00ebn gati p\u00ebr implementim t\u00eb shpejt\u00eb. Pas rreth 3 muajsh filluam t\u00eb nxjerrim komponentin e par\u00eb. Pas 6 muajsh ne u larguam 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\u00eb karta. A \u00ebsht\u00eb planifikuar integrimi me Yandex.Maps dhe ve\u00e7an\u00ebrisht me kartat e personalizuara t\u00eb Yandex?<\/em><\/p>\n<p><\/p>\n<p>Kam provuar t\u00eb integrohem n\u00eb vend t\u00eb Google map, por nuk gjeta tem\u00ebn e err\u00ebt n\u00eb Yandex.Maps. Nuk e theksova nj\u00eb pjes\u00eb. Do t\u00eb rrok p\u00ebr ta plot\u00ebsuar. <\/p>\n<p><\/p>\n<p>Slides \u2013 Google map. Atje ka komand\u00ebn \"DRAW_GMAPS\", e cila vizaton hart\u00ebn. Ka komand\u00ebn \"DRAW_YMAPS\", dmth. mund t\u00eb vizatoj\u00eb hart\u00ebn e Yandex. Dhe n\u00eb fakt n\u00ebn k\u00ebt\u00eb komand\u00eb ndodhet Javascript, dmth. t\u00eb dh\u00ebnat q\u00eb merrni nga ClickHouse mund t'i d\u00ebrgoni n\u00eb Javascript, t\u00eb cilin e shkruani k\u00ebtu. Dhe ju keni nj\u00eb zon\u00eb n\u00eb dalje ku ajo duhet t\u00eb vizatohet. Mund t\u00eb vizatoni \u00e7do grafik, dmth. \u00e7do grafik, hart\u00eb, mund t\u00eb vizatoni komponentin tuaj t\u00eb personalizuar. Para k\u00ebsaj kisha nj\u00eb bibliotek\u00eb tjet\u00ebr p\u00ebr vizatimin e grafik\u00ebve.<\/p>\n<p><\/p>\n<p><em>Dmth. ka nj\u00eb mjet p\u00ebr personalizimin e funksionalitetit t\u00eb shfaqjes?<\/em><\/p>\n<p><\/p>\n<p>\u00c7do gj\u00eb. Mund t\u00eb merrni dhe t\u00eb ndryshoni ngjyrat e k\u00ebtyre pikave, duke i b\u00ebr\u00eb ato jo t\u00eb kuqe, por t\u00eb blu, t\u00eb gjelbra.<\/p>\n<p><\/p>\n<p><em>Faleminderit p\u00ebr prezantimin! Keni pasur nj\u00eb slide, ku jan\u00eb paraqitur mjete alternative p\u00ebr k\u00ebrkesat<\/em> <em>ClickHouse<\/em> <em>p\u00ebr nd\u00ebrtimin e dashboard-eve, raporteve analitike. E kuptova se n\u00eb momentin kur filluat t\u00eb punoni me<\/em> <em>ClickHouse, p\u00ebr k\u00ebto mjete nuk jan\u00eb shkruar adaptues. Dhe m\u00eb intereson pse keni vendosur t\u00eb krijoni mjetin tuaj, n\u00eb vend q\u00eb t\u00eb shkruanit nj\u00eb adaptues p\u00ebr ndonj\u00eb mjet t\u00eb gatsh\u00ebm? Mendoj se ndreqja e redaktorit t\u00eb testeve \u00ebsht\u00eb e shpejt\u00eb. Pse vendos\u00ebt t\u00eb b\u00ebni kaq shum\u00eb pun\u00eb?<\/em><\/p>\n<p><\/p>\n<p>K\u00ebtu ka nj\u00eb moment interesant \u2013 \u00e7\u00ebshtja \u00ebsht\u00eb se un\u00eb jam drejtor teknik, jo nj\u00eb shkenc\u00ebtar t\u00eb dh\u00ebnash. N\u00eb at\u00eb koh\u00eb, kur filluam t\u00eb implementonim Druid, n\u00eb roadmap-in tim kishte rreth 50 % detyrash \u2013 le t\u00eb llogarisim k\u00ebt\u00eb ose le t\u00eb llogarisim at\u00eb, ose ta analizojm\u00eb k\u00ebt\u00eb. Dhe ndodhi q\u00eb ne implementuam ClickHouse. Dhe fillova t\u00eb nd\u00ebrtoja shpejt, llogariti, mbylla shpejt roadmap-in tim. Dhe n\u00eb at\u00eb moment kuptova se 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. E shikova si t\u00eb plot\u00ebsoj Zeppelin. Kam nj\u00eb pak pak dashuri p\u00ebr programimin e tij. E shikova Redash-in si t\u00eb plot\u00ebsoj, por m\u00eb mungonte nj\u00eb redaktor normal. Dhe SuperSet gjithashtu \u00ebsht\u00eb shkruar n\u00eb at\u00eb gjuh\u00eb q\u00eb nuk e dua shum\u00eb. Dhe prandaj vendosa t\u00eb krijoj nj\u00eb bi\u00e7iklet\u00eb, dhe ja \u00e7far\u00eb doli.<\/p>\n<p><\/p>\n<p><em>Igor, a pranoni Pull Request?<\/em><\/p>\n<p><\/p>\n<p>Po.<\/p>\n<p><\/p>\n<p><em>Faleminderit shum\u00eb p\u00ebr prezantimin! Dhe dy pyetje. E para \u2013 nuk flisni shum\u00eb mir\u00eb p\u00ebr<\/em> Javascript. A keni 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 \u00ebsht\u00eb framework-u?<\/p>\n<p><\/p>\n<p>Angular.<\/p>\n<p><\/p>\n<p><em>E kuptoj. Dhe pyetja e dyt\u00eb. A keni konsideruar<\/em> R <em>dhe<\/em> *<strong>Shiny**<\/strong>?*<\/p>\n<p><\/p>\n<p>E kam konsideruar. Kam luajtur me t\u00eb. <\/p>\n<p><\/p>\n<p><em>Mund t\u00eb kishet shkruar nj\u00eb adaptues t\u00eb thjesht\u00eb.<\/em><\/p>\n<p><\/p>\n<p>Ai \u00ebsht\u00eb aty. Duket se komuniteti e ka b\u00ebr\u00eb, por, si\u00e7 thash\u00eb n\u00eb pyetjen e m\u00ebparshme, m\u00eb p\u00eblqeu t\u00eb eksperimentoj vet\u00eb.<\/p>\n<p><\/p>\n<p>*Jo, n\u00eb lidhje me vizualizimin, atje ka.<\/p>\n<p><\/p>\n<p>Ti thua se ka nj\u00eb gj\u00eb dhe ajo do t\u00eb t\u00eb vizualizoj\u00eb nj\u00eb grafik. Hapa libra p\u00ebr vizualizimin e t\u00eb dh\u00ebnave. Dhe mendoj: 'Le t\u00eb provosh t\u00eb vizualizosh k\u00ebto t\u00eb dh\u00ebna. Do ta shkruaj vet\u00eb, q\u00eb t\u00eb vizualizoj\u00eb t\u00eb dh\u00ebnat'. Dhe fillova t\u00eb kuptoj m\u00eb mir\u00eb teknologjin\u00eb e paraqitjes s\u00eb t\u00eb dh\u00ebnave. Dhe n\u00ebse do t\u00eb kisha marr\u00eb nj\u00eb komponent t\u00eb gatsh\u00ebm, un\u00eb personalisht do t\u00eb m\u00ebsova m\u00eb pak se si ta p\u00ebrdorja, pra dhe n\u00eb lidhje me vizualizimin. Por k\u00ebshtu \u2013 po, R m\u00eb p\u00eblqeu, por akoma nuk e kam lexuar librin \"R p\u00ebr fillestar\u00ebt\". <\/p>\n<p><\/p>\n<p><em>Faleminderit!<\/em><\/p>\n<p><\/p>\n<p><em>Pyetje e thjesht\u00eb. A ka ndonj\u00eb mund\u00ebsi t\u00eb nxjerr\u00ebsh shpejt nj\u00eb tabel\u00eb, nj\u00eb grafik?<\/em><\/p>\n<p><\/p>\n<p>Mund t\u00eb nxirret n\u00eb CSV, n\u00eb Excel.<\/p>\n<p><\/p>\n<p><em>Jo t\u00eb dh\u00ebnat, por nj\u00eb tabel\u00eb t\u00eb gatshme, nj\u00eb grafik t\u00eb gatsh\u00ebm? P\u00ebr shembull, p\u00ebr ta treguar shefit.<\/em><\/p>\n<p><\/p>\n<p>Ka nj\u00eb buton \"Shkarko\" dhe ka nj\u00eb buton \"Shkarko grafik\u00ebn n\u00eb png, n\u00eb jpg\".<\/p>\n<p><\/p>\n<p><em>Faleminderit!<\/em><\/p>\n<p><\/p>\n<p>P.S. Mini-udh\u00ebzimi p\u00ebr instalimin e tabix<\/p>\n<p><\/p>\n<ul>\n<li>Descargar <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/smi2\/tabix.ui\/releases\">l\u00ebshimi m\u00eb i fundit<\/a><\/noindex><\/li>\n<li>Shkarkoni, kopjoni direktorin\u00eb <code>build<\/code> n\u00eb root_path t\u00eb nginx<\/li>\n<li>Konfiguroni 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.2 - 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.2\" \/>\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 analiz\u00eb t\u00eb dh\u00ebnash vizualmente t\u00eb shpejt\u00eb dhe t\u00eb qart\u00eb n\u00eb Tabix. Igor Strikhary | ProHoster","description":"Ju ftoj t\u00eb njihni interpretimin e raportit t\u00eb vitit 2017 nga Igor Strikhary \u00abClickHouse \u2013 analiz\u00eb t\u00eb dh\u00ebnash vizualmente t\u00eb shpejt\u00eb dhe t\u00eb qart\u00eb n\u00eb Tabix\u00bb. Nd\u00ebrfaqja n\u00eb internet 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}]}}