hive 列转行，行转列

1   列转行

select * from student_relation 展示原始数据

select master_student_id,student_id from student_relation lateral view explode(split(relation_student_id,','))  temTable as student_id      结果如下

2 行转列

select * from tmp 原始数据如下：

select master_student_id,concat_ws(',', collect_list(student_id)) from tmp group by master_student_id  结果如下：

3 时间戳函数

select unix_timestamp('2020-12-12 23:59:59')

select from_unixtime(1607788799,'yyyy-MM-dd HH:mm:ss')