Hive table replace timestamp column NULL value with Custom default

user_9714762 0
Viewed 358

I understand how to keep default value as current timestamp, But I have requirement to replace NULL value in timestamp column with custom date/timestamp.

hadoop2 hive
1 Answers

There is coalesce function that you can use, e.g.,

select coalesce(column_name, cast("2020-07-28 12:34:56" as timestamp))
user_55348590
Related