[04:25:30] Hi Everybody: I'm kicking off a job to build a month's worth of pageview sessions. The cluster looks pretty quiet, so it seems like a good time, but let me know if you notice any hiccups. [04:25:51] I expect it will use 10% of the cluster for a few hours. [09:06:13] milimetric: a tidied up/document version of the query you wrote + results :) https://phabricator.wikimedia.org/P6120 [10:04:12] phuedx|afk: ah, weird, wonder why the dividing wasn’t working for me. Btw though, UA is considered slightly sensitive at these small sample sizes. So that paste divulges a bit too much information. You could remove the actual count, and the details about the date from the query and description without losing too much value. I assume it’s more the relative rank you care about. [16:53:50] Hey... is there anyone who can take a look at our Analytics Cluster - I seem to be experiencing some problems there, probably because of my misuse of HiveQL queries..? [19:47:53] omg, 1200 emails [20:21:27] 10Analytics-Kanban: Fix MediaWiki snapshot cleaner cron job - https://phabricator.wikimedia.org/T178256#3686096 (10mforns) [20:52:24] Shilad (or anyone else who may be concerned about their use of computing resources on Hive): seen https://wikitech.wikimedia.org/wiki/Analytics/Systems/Cluster/Hive/Queries#Run_long_queries_in_a_screen_session_and_in_the_nice_queue ?