Join this group if you use the Hadoop version of DMX.
I need to develop a custom functions in SyncSort DMX-H using Java/Scala/Groovy i.e other than C / C++. Is it possible to develop, if yes could you please share the documentation for the same.
Below is my requirement :
Left hand side is a data value in raw format and I need to convert it into right hand side format i.e. eventually into ISO format. We are missing seconds when we try to convert using TO_DATE function.
Could you please suggest a better solution to handle this in SyncSort DMX-H (this is a column value from one Hive table to another Hive table)
2015-04-29-126.96.36.1994372 -> 2015-04-29 14:20:10.574372
08-NOV-25 13.00.00.123450 -> 2015-08-25 13:00:00.123450
17-OCT-15 06.57.26.245552 PM -> 2015-10-17 18:57:26.245552
Kishore Veleti A.V.K.