Re: striim date function

Posted by Roshan on Jul 24, 2022; 2:58pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/striim-date-function-tp10983p11000.html

In fact the time on Kudu had a discrepency of 4 hours as compared to Oracle date fields (source). Striim provided a UDF (jar file) which contains code to add 4 hours for any timestamp/date datatypes coming from source Oracle stream.

The UDF had an issue - date fields were set to Joda time which is correct while timestamp and timestamp with timezone were set to local time. So they did the correction in the UDF and set  timestamp and timestamp with timezone to JODA time.