Impala to_timestamp('d/M/yyyy H:m:s')for Adobe post_t_time_info

Impala to_timestamp('d/M/yyyy H:m:s')for Adobe post_t_time_info

I've invested a few day to solve the problem of Adobe Click Stream date format to unix time stamp.I want to use the date_time of Clickstreamd Data but it's not relevant to interval between 2 different pages. Unix date/time conversion of '1/6/2019 1:5:1' is required. In general, Unix time format is like 'YYYY-MM-DD HH:mm:ss' but Adobe data format is not. Thus I've tested multiple format and finall