apache spark sqlAggregate across

apache spark sql - Aggregate across multiple columns of different types when pivoting in pyspark - Stack Overflow
I have a melted table of the form:+------+---------+--------------+------------+--------------+| time
admin6小时前
40