How to avoid push down EXTRACT() function to ORACLE DB
Issue
- Some column in a ORACLE db table is defined as DATE
- In a source model, the column is mapped as timestamp
- If user execute query like "select EXTRACT(hour columnname) from xxxxx", it throws ORA-30076
Environment
- Red Hat JBoss Data Virtualization
- 6.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
