m-lab / etl-schema

71%

main: 71%

LAST BUILD ON BRANCH v3.14.0

branch: v3.14.0

CHANGE BRANCH

x

Reset

• v3.14.0
• 3.15.1
• 3.9.1
• KR-template
• add-MeanThroughputMbps-to-downloads
• add-archive-url
• add-asn
• dependabot/go_modules/golang.org/x/net-0.7.0
• dependabot/go_modules/golang.org/x/sys-0.1.0
• dependabot/go_modules/golang.org/x/text-0.3.8
• main
• master
• mm-inspector
• mm_intermediate_names
• new_traceroute
• prod-3.1.1-rollback
• prod-3.2.0
• prod-3.2.1
• prod-3.3.0
• rollback
• sandbox-add-stats-pipeline-views
• sandbox-add-stats-views-to-bash-script
• sandbox-add-tcpinfo-hack
• sandbox-addtrace
• sandbox-cristinaleon-1.20
• sandbox-cristinaleon-create-view-revtr
• sandbox-cristinaleon-delete-aggregate
• sandbox-cristinaleon-delete-traceroute-legacy
• sandbox-cristinaleon-early-exit-filter
• sandbox-cristinaleon-legacy-paris
• sandbox-cristinaleon-modules
• sandbox-cristinaleon-pcap
• sandbox-cristinaleon-ranked-spoofers
• sandbox-cristinaleon-remove-scamper1_hopannotation1
• sandbox-cristinaleon-revtr
• sandbox-cristinaleon-revtr_raw
• sandbox-cristinaleon-scamper1-hopannotation1
• sandbox-cristinaleon-scamper1-hopannotation1-view
• sandbox-cristinaleon-travis
• sandbox-cristinaleon-wehe-project
• sandbox-critzo
• sandbox-integer-asn
• sandbox-laiyi-statistics-merge
• sandbox-mattmathis-unified
• sandbox-mattmathis-unified-uploads
• sandbox-mm-autojoin
• sandbox-mm-autojoin2
• sandbox-mm-downloads
• sandbox-mm-fast-filter
• sandbox-mm-intermediate-names
• sandbox-mm-ndt7-01
• sandbox-mm-ndt7-02
• sandbox-mm-ndt7-03
• sandbox-mm-network1
• sandbox-mm-network2
• sandbox-mm-network3
• sandbox-mm-network4
• sandbox-mm-network5
• sandbox-mm-network6
• sandbox-mm-network7
• sandbox-mm-nofilter
• sandbox-mm-p2s
• sandbox-mm-update-prod
• sandbox-mm-uploads
• sandbox-mm-v01
• sandbox-mm-v02
• sandbox-mm-v03
• sandbox-mm-viewnames1
• sandbox-radius
• sandbox-roberto-add-latency1-view
• sandbox-roberto-download-rates-view
• sandbox-roberto-latency1-view
• sandbox-roberto-msak-views
• sandbox-roberto-rename-ndt8-throughput1
• sandbox-roberto-switch-view
• sandbox-roberto-throughput1-view
• sandbox-saied-go118
• sandbox-soltesz
• sandbox-soltesz-add-gke-ips
• sandbox-soltesz-annotation2
• sandbox-soltesz-autojoin-public
• sandbox-soltesz-bqmk
• sandbox-soltesz-cloudflare-passthrough
• sandbox-soltesz-combo-ops
• sandbox-soltesz-create-switch-sidestream
• sandbox-soltesz-expose-early-exit-cond
• sandbox-soltesz-findtables
• sandbox-soltesz-fix
• sandbox-soltesz-fix-ndt5-errors
• sandbox-soltesz-fix-ndt7-region
• sandbox-soltesz-go118
• sandbox-soltesz-legacy
• sandbox-soltesz-library
• sandbox-soltesz-mask-region
• sandbox-soltesz-ndt5
• sandbox-soltesz-ndt5-legacy
• sandbox-soltesz-null-region
• sandbox-soltesz-opsbyos
• sandbox-soltesz-pass-through
• sandbox-soltesz-preserve-region-type
• sandbox-soltesz-remove-library
• sandbox-soltesz-static-web100-unified
• sandbox-soltesz-v2-tcpinfo
• sandbox-soltesz-web100-geo2
• sandbox-soltesz-web100-static
• sandbox-soltesz-web100-static-passthrough
• sandbox-soltesz-web100-static-use
• sandbox-soltesz-website
• sandbox-soltesz2
• sandbox-traceroute
• sandbox-update-ndt-unified-ddescriptions
• sandbox-update-stats-views
• stephen-soltesz-patch-1
• update-stats-views
• update-views
• v3.10.0
• v3.11.0
• v3.12.0
• v3.13.0
• v3.14.1
• v3.15
• v3.15.1
• v3.15.2
• v3.16
• v3.17
• v3.19
• v3.20
• v3.21
• v3.3.0
• v3.3.1
• v3.32
• v3.33
• v3.34
• v3.34.1
• v3.35.0
• v3.35.1
• v3.36.0
• v3.37.1
• v3.38.0
• v3.39.0
• v3.4.0
• v3.40.0
• v3.40.1
• v3.41.0
• v3.41.1
• v3.42.0
• v3.43.0
• v3.5.0
• v3.6.0
• v3.7.0
• v3.8.0
• v3.9.0
• v3.9.1
• v4.0.0
• v4.1.0
• v4.2.0
• v4.7.3
• v4.7.4
• v4.7.5
• v4.7.6
• v4.7.7
• v4.8.0
• v4.8.1
• v4.9.0
• v4.9.1
• v4.9.2
• views

Build # 409

Build Type

push

travis-ci

Committed by web-flow

Commit Message

Update unified views to better align with the new parsers and gardner (#79)

* Update unified views to better align with the new parsers and gardner

These are all non-breaking for all proper queries:
- Discard rows missing UUIDs earlier in the process (this improves join performance)
- Restore join on partition date to the UUID join (further improve join performance)
- Make 'id' a top level field (but no change to test_date)
- Added server.Site and server.Machine
- Make uncomputable upload loss rate Null (not 0)
- Updated _internal202004 to _internal202006 (not visible in the unified views)
- Expose parsers within _internal202006: NDT5parser, TCPparser, Web100parser
- Exclude corrupted rows (more than 1E14 bytes received)
- Internal cosmetic changes
- Add a date column in the appropriate position, add test_data as the last column

Run Details

133 of 187 relevant lines covered (71.12%)

2.49 hits per line