SAP HANA Version: hana1sp12
There have a SQL statement is:
JOIN ON CREATE_DATE >= MODIFY_DATE
Because I have a lot of nodes in the old calculation view, and I want to implement new nodes will use non equi-join >= on the calculation view. After my search on the Internet, I saw people suggested to use 'temporal join'. But it is disable on calculation view at my hana1sp12 version. Then, I find some people have same issue(https://answers.sap.com/questions/133294/temporal-joins-option-is-disabled-in-hana-calculat.html). But no one know the exactly solution or answer about this issue.
Does someone could give suggestions for me if I need to implement in calculation view, or do I have work around methods to implement on calculation view?
Thank you.
J.K