[08:18:37] Analytics-Kanban: Gather user feedback from druid prototype for pageview data - https://phabricator.wikimedia.org/T136836#2378746 (Nuria) @Tbayer: query format is indeed very different than the one you would use in hive. Also, query times and optimizations needed are different in either data store. [08:22:58] ori: sorry we are in Berlin - we don't use the X-Analytics data from these clusters [08:23:07] but we can't know if other people use it [08:25:59] these are the things we are aware of - https://wikitech.wikimedia.org/wiki/X-Analytics [08:26:16] but people can set whatever from the php extension - and may not be documented [10:16:04] Analytics-Cluster, Operations, Packaging: libcglib3-java replaces libcglib-java in Jessie - https://phabricator.wikimedia.org/T137791#2379016 (Reedy) [11:05:08] https://www.lieferando.de/lieferservice-pizzeria-am-wasserturm-berlin#! [11:36:17] mobrovac: hello! Whenever you have time can we chat about EventBus reboots? [11:37:00] elukey: hey! [11:37:15] i've got a couple of things on my plate that i absolutely need to address [11:37:36] so a bit later in the day [11:37:38] ? [11:39:21] yes sure! I am in Berlin with the Analytics team so it is not that urgent, just wanted to check with you the next steps [11:39:25] whenever you have time :) [11:39:40] have a nice offsite guys! [13:03:05] o/ [13:06:02] Hey joal & milimetric. Anything to discuss re. live-systems? [13:09:49] * halfak hops out of call [13:09:57] Ping me if you want to try again :) [13:11:24] Analytics-Kanban: Prototype Data Pipeline on Druid - https://phabricator.wikimedia.org/T130258#2379455 (Nuria) [13:11:26] Analytics-Kanban: Get pageview dataset ready to be loaded to druid to test querying capabilities - https://phabricator.wikimedia.org/T136330#2379454 (Nuria) Open>Resolved [13:11:42] Analytics-Kanban: Create separate Analytics-CI gerrit group and add maven-release-user - https://phabricator.wikimedia.org/T136221#2379456 (Nuria) Open>Resolved [13:11:56] Analytics-Kanban: Remove firewsll blocking Spark on stat1004 - https://phabricator.wikimedia.org/T135369#2379470 (Nuria) Open>Resolved [13:18:52] halfak: o/ ! [13:19:20] halfak: please accept our apologizes, we're in Berlin having team offsite, and completely forgot about the meeting [13:19:33] Oh! No sweat! Are you at WMDE? [13:19:40] We are ! [13:19:43] Analytics-Kanban: Remove firewsll blocking Spark on stat1004 - https://phabricator.wikimedia.org/T135369#2296653 (MoritzMuehlenhoff) Well, base::firewall should certainly be applied on stat1004 as well, we only need to track down what broke when it was briefly applied [13:19:46] We said hello to Amir :) [13:19:55] Great! That's what I was going to ask :D [13:19:59] huhu [13:20:10] Have good offsite :) [13:20:19] Thanks mate, TTYL [13:20:22] o/ [13:22:48] apropos https://phabricator.wikimedia.org/T137609 , could one use these last-access cookies on upload.wikimedia.org to calculate unique devices estimates for that domain too? looks like that could be a good approximation for global uniques (across all projects) [13:23:12] ...or is that problematic because it's technically a third-party domain? [13:44:15] madhuvishy (re ori's question): does the is_zero field in the webrequest table depend on X-Analytics? [13:44:24] (or other fields there apart from x_analytics itself) [13:44:40] HaeB: checking [13:51:07] HaeB: yeah [13:51:12] that's where it's coming from [13:51:22] ....because that has definitely been used for upload.wm [13:51:31] https://github.com/wikimedia/analytics-refinery/blob/385d304f28be7e469e62e4bc037fe8d1b854d589/oozie/webrequest/load/refine_webrequest.hql#L100 [13:51:35] ...and will be again [13:51:36] ah [13:51:49] interesting - ori ^ [13:57:08] wikimedia/mediawiki-extensions-EventLogging#563 (wmf/1.28.0-wmf.6 - e41cd44 : Antoine Musso): The build has errored. [13:57:08] Change view : https://github.com/wikimedia/mediawiki-extensions-EventLogging/commit/e41cd449f801 [13:57:08] Build details : https://travis-ci.org/wikimedia/mediawiki-extensions-EventLogging/builds/137516784 [15:03:34] jand_wmde: analytics documentation starts with requesting access: https://wikitech.wikimedia.org/wiki/Analytics/Data_access [15:21:22] jand_wmde: here's an example report configuration: https://github.com/wikimedia/analytics-limn-flow-data/tree/master/flow