摘要:
1. 获取当前时间 --hive hive select from_unixtime(unix_timestamp()); --> 2021-01-06 22:53:16 --精确到今天的时分秒 select from_unixtime(unix_timestamp('2021-12-07 13:0 阅读全文
摘要:
递归 WITH RECURSIVE t(n) AS ( values(1) UNION ALL SELECT (n + 1) as n FROM t WHERE n in (1,2,3) ) select * from t; 传参: PREPARE myquery FROM SELECT userK 阅读全文