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 of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.