Improve HiveSQL queries

Arcangerequested to merge
_arcange_/hive-open-stats:_arcange_-dev-patch-86024 into dev
  • better use of indexes
  • remove useless tests
  • avoid computing value on each row
  • use UTC dates

Merge request reports