相信生活

时间转时间戳： cast(to_unixtime(timestamp ‘2016-09-01 01:00:00’) as bigint) int 转 varchar ：cast(1 as varchar) varchar 转int：cast(‘1’ as bigint) map数据查询：element_at(url_parsed,‘do’) 数据包含 contains(x, element) 时...

presto后端跑数据 1.进入服务器 2.切换到presto目录 cd /opt/presto 3.运行语句 ./cli.sh “sql” >test.txt 注：如果无法运行，则先sudo su - /opt/presto/cli.sh " sql语句 ">recent_days_topic_id.txt ...