Hi All, How do I generate current UTC timestamp using spark sql?
When I do curent_timestamp() it is giving me local time. to_utc_timestamp(current_time(), ????) takes timezone in the second parameter and I see no udf that can give me current timezone. when I do spark.conf.set('spark.sql.session.timeZone', 'UTC') current_timestamp() But this wont work for me because I dont have access to spark conf object . Any other solutions using raw sql alone and default udfs would be helpful. Thanks!