Fix CI builder tag and CTE scope bug

Dan Notesteinrequested to merge
cursor-fix-for-determinism into develop

Summary

  • Switch data-cache-storage jobs to hive-builder-9 to prevent cache mismatch between builders
  • Fix CTE scope bug: use temp table for cursor iteration (CTEs are only accessible within their WITH statement)

Changes

  1. CI fix: Add hive-builder-9 tag to ensure all data-cache-storage jobs run on the same machine
  2. SQL fix: Replace CTE with temp table for cursor-based reputation processing

These changes were tested in pipeline 140304 which passed successfully.

Merge request reports