How can we use row_number() in apache beam sql

Question

I tried that but getting following error. eg:

SELECT RELEASE_ORDER_KEY,ORDER_LINE_KEY,ORDER_HEADER_KEY,ROW_NUMBER() OVER (PARTITION BY ORDER_LINE_KEY ORDER BY RELEASE_ORDER_KEY) row_num FROM OMS_DATALAKE_ORDER_RELEASE_TAX ORDER BY ORDER_LINE_KEY LIMIT 5

Error:

Exception in thread "main" java.lang.RuntimeException: cannot translate call ROW_NUMBER() OVER (PARTITION BY $t1 ORDER BY $t0 ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

Answer 1

BeamSQL does not support ROW_NUMBER() function(at least until 2.15).