79192276

Date: 2024-11-15 12:02:01
Score: 4.5
Natty:
Report link

guys!

So, my team migrated from Oracle to Redhsift and we need to move the logic. Redhsift doesn't have MODEL clause and I have trouble with implementation of this recursive logic into regular sql with windowing functions (LAG). Would you share some hints on how to approach?

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Ends in question mark (2):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Kondjitsu