Changes between Initial Version and Version 1 of table_example3

Timestamp:

09/17/2012 12:28:17 PM (14 years ago)

Author:

liaojiaohe

Comment:

--

table_example3

@@ +1 @@
+需要从各维度统计下载的情况
+{{{
+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
+}}}