It appears that neither REGEXP_REPLACE, nor casting or converting a decimal data type to a string, gets pushed down to Oracle. It seems the Oracle JDBC yaml file must not provide a mapping for these items.
I would like to request that you enhance the Oracle JDBC plugin to accommodate these items in a future release. And/or/better yet… it would be nice if you would make Oracle’s (and other’s) JDBC ARP plugin open source and allow others to contribute when missing config items are found, like we can for the Snowflake plugin.
Lack of pushdown seriously hampers our query performance against large Oracle datasets.
2 Likes