1.hive去掉前一个字符,和后一个字符
如果是string类型:
select substr("[1,2,3]",2,length("[1,2,3]")-2);
如果是ARRAY<STRING> 类型:
LATERAL VIEW EXPLODE(apps) x AS app
2、时间相减
秒:(unix_timestamp(check_time) - unix_timestamp(create_time))
分钟 (unix_timestamp(check_time) - unix_timestamp(create_time))/60
小时(unix_timestamp(check_time) - unix_timestamp(create_time))/60/60