1053632 - fetch-adi-from-hive should collapse release%->release

Status: RESOLVED FIXED

(Socorro :: Database, task)

Description

[Robert Helmer [:rhelmer]]

The old ADI source raw_adu, already had all release% channels collapsed into one release channel.

Socorro currently uses build_type_enum when filtering these into product_adu, I think the most simplest thing would be to break this for the "release" case and have them do (update_channel ILIKE 'release%' OR update_channel IN ('release', 'nightly', 'aurora'))

Later we might want to make the import process handle this, instead, but I would like to avoid that for now. It's going to be a perf hit/complexity somewhere either way.

Comment 1

[Robert Helmer [:rhelmer]]

Upon investigation, it's just less hassle to do this right.

Comment 2

[Robert Kaiser]

Also, did you omit 'beta' intentionally in comment #0?

Comment 3

[Robert Helmer [:rhelmer]]

(In reply to Robert Kaiser (:[e-mail], slow reaction due to vacation backlog) from comment #2)
> Also, did you omit 'beta' intentionally in comment #0?

Well I changed the approach (per comment 1) so it's no longer needed - but betas are handled separately in the file I was referring to :)

Comment 4

[[github robot]]

Commits pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/2a5c27408c26d691ebfb096d491720f64c2a0d24
fix bug 1053632 - collapse all release channels in fetch-adi-from-hive

https://github.com/mozilla/socorro/commit/587b61b1894b227b0c32e0db040033cb7803ac5e
Merge pull request #2289 from rhelmer/bug1053632-collapse-release-channels

fix bug 1053632 - collapse all release channels in fetch-adi-from-hive

Comment 5

[Robert Helmer [:rhelmer]]

Migration run on stage, backfilling..

Comment 6

[Robert Helmer [:rhelmer]]

Migration run on prod.