odota / core

Open source Dota 2 data platform
https://www.opendota.com
MIT License
1.5k stars 300 forks source link

Fix data issues #2763

Closed howardchung closed 5 months ago

howardchung commented 5 months ago

Some matches have null hero_ids. Add a validation at insert time to make sure all players have hero_id

https://www.opendota.com/explorer?sql=select%20match_id%2C%20hero_id%20from%20player_matches%20where%20hero_id%20is%20null%20order%20by%20match_id%20limit%2010%3B&format=

Match 1416146420 is crashing the parser (this is a really old match)