需要从各维度统计下载的情况 {{{ Categorize downloads by the following hierarchies Date (UTC) Year Month Day Hour Minute Product Product Name Product Major Version Product Full Version Upgrade From Version ( determined by version string after -partial suffix ) Rebuild tag ( suffix string after primary version string ) Target OS ( from &os= parameter ) Request Info Download Type manual | partial | complete ( determined by -partial vs -complete vs any other ) Request Type download | check | other ( determined by GET vs HEAD vs any other ) Request Result success | failure ( determined via 302 vs 404 or any other ) Locale ( localization of product ) Location Continent Country Region City Latitude Longitude User Agent Info ( Possible to be deferred for later version ) UA OS Platform OS Name OS Version UA Browser Classification Desktop | Mobile | Spider | Bot | Other | Unknown Category Gecko | MSIE | WebKit | Opera | Other | Unknown Name Version Engine A Engine B }}} 即时表,每分钟一条记录,rowkey 是时间,各种条件的统计在column里面保存 {{{ Table Name: dmo_metrics_realtime Rowkey format concatenation of {utc_timestamp_to_minute} (i.e. yyyy-mm-ddTHH:MM ) Counter Columns dimension product column name format counter:product: {download_type}: {product_name}: {product_major_version}: {product_version}: {product_os}: {product_rebuild}: {upgrade_from} dimension server_info column name format counter:server_info: {datacenter_code}: {server_name} dimension locale column name format counter:locale: {locale_code} dimension location column name format counter:location: {continent_code}: {country_code}: {region_code}: {city_name}: {latitude}: {longitude} dimension user_agent_info *TBD* examples rowkey: minutes_2010-05-24T03:33 columns: counter:product:manual:firefox:3.6:3.6.1:win:: = 1356 counter:product:complete:firefox:3.6:3.6.7:win:: = 12456 counter:product:partial:firefox:3.6:3.6.7:win::3.6.6 = 16334 counter:product:manual:thunderbird:3.1:3.1b2:mac:: = 50 counter:locale:en-US = 50000 counter:locale:pt-PT = 400 counter:locale:ru = 430 counter:location:NA:US:NH:0.000:0.000 = 30 counter:location:NA:US:CA:30.555:-100.999 = 5000 }}} 每小时进行多维度的统计[[BR]] {{{ Table Name: dmo_metrics_hourly Rowkey format concatenation of {utc_timestamp_to_hour}_ {datacenter_code}:{server_name}_ {download_type}:{product_name}:{product_major_version}:{product_version}: {product_os}:{product_rebuild}:{upgrade_from}_ {locale_code}_ {continent_code}:{country_code}:{region_code}:{city_name}:{latitude}:{longitude} Dimension Columns product dimension:product_download_type = {download_type} dimension:product_name = {product_name} dimension:product_major_version = {product_major_version} dimension:product_version = {product_version} dimension:product_os = {product_os} dimension:product_rebuild = {product_rebuild} dimension:product_upgrade_from = {upgrade_from} server_info dimension:datacenter_code = {datacenter_code} dimension:server_name = {server_name} locale dimension:locale_code = {locale_code} location dimension:location_continent_code = {continent_code} dimension:location_country_code = {country_code} dimension:location_region_code = {region_code} dimension:location_city_name = {city_name} dimension:location_latitude = {latitude} dimension:location_longitude = {longitude} dimension user_agent_info *TBD* Counter Column -- long integer updated via incrementColumn API counter:requests }}}