Add a column in the refined tables with a map of the x-analytics header.
What way, you can write a hive query with something like x-annalytics['zero'] = 1, in stead of using a UDF to parse the field.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | None | T88647 {bear} Last Access Counts | |||
| Declined | • kevinator | T88813 Implement Last-Access cookie [34 pts] {bear} | |||
| Resolved | • kevinator | T92435 Code changes in VCL to add a Last-Access cookie to track "top domain" uniques [13 pts] {bear} | |||
| Resolved | • madhuvishy | T92977 Implement Unique Devices report on cluster using x-analytics header & last access date {bear} [13 pts] | |||
| Resolved | Nuria | T94481 Mobile PMs has visualization on session-related metrics from Wikipedia Apps | |||
| Resolved | • madhuvishy | T97876 Productionize reporting of app session metrics {hawk} [8pts] | |||
| Resolved | Nuria | T86535 Mobile PMs has reports on session-related metrics from Wikipedia Apps {hawk} | |||
| Resolved | JAllemandou | T89396 Add x_analytics map to refined tables {hawk} |
Event Timeline
Comment Actions
Do we really want to provide dedicated fields (schema modification, data redundancy), or do we want provide an easy to use UDF ?
Comment Actions
Hm, you know...I think maybe instead of refining these fields, we should just refine the x_analytics field into a map instead of a string. That way we don't have to special case for certain fields, and we can still select on them without having to resort to a special UDF or regex.