About RNN

RNN · ‎10-24-2019

Hi Team, I have a hive table column under this format, 2019-Oct-14 20:00:01.027898 as string but I want to insert in to another table as timestamp. I tried using hive date functions but its cutting down the milliseconds, or its rounding up. I want the string to be stored exactly as it is in the table. Could someone please provide me the easiest solution. Thanks, RNN

RNN · ‎10-23-2019

Thanks for your reply, but it didn't work. I tried using other functions but it brings up the date time without milliseconds. But I want the milliseconds as well.

RNN · ‎10-23-2019

Thanks for the solution. Could you please guide me for hive too, converting string to timestamp for the same formatted string.

RNN · ‎10-23-2019

Hi Team, I have an impala table column under this format, 2019-Oct-14 20:00:01.027898 as string but I want to insert in to another table as timestamp. I tried so many ways but its giving me null. Could you please guide me the easiest way to store this formatted string as timestamp in impala. Thanks, RNN

Online	Offline
Last Visited	‎07-09-2020 03:27 PM

Member Since	‎10-23-2019 08:48 AM
Last Visited	‎07-09-2020 03:27 PM
Posts	4

Cloudera Community

Hive - Convert Formatted String to Timestamp

Re: Impala - Convert String to Timestamp

Re: Impala - Convert String to Timestamp

Impala - Convert String to Timestamp