Good Day, Everyone!
I have a problem. I made interface in ODI (tecnology - TERADATA) and used OLAP functions in it. For example
| coalesce(((tc.data-min(tc.DATA) OVER (PARTITION BY tc.session_id | ORDER BY years.year_id ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING ))/12),tc.data) |
But ODI generates SQL request using group by: therefore I recieved error
SQLState: HY000
ErrorCode: 3504
Query 1 of 1, Rows read: 132, Elapsed time (seconds) - Total: 1,844, SQL query: 1,844, Building output: 0
Error: [Teradata Database] [TeraJDBC 13.10.00.01] [Error 3504] [SQLState HY000] Selected non-aggregate values must be part of the associated group.
SQLState: HY000
ErrorCode: 3504
Why it not understand OLAP functions (OVER PARTITION BY) ? Is it possible to set up ODI to understand