![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
xiaoyutongxue6
探索新思路、实现新突破、取得新成绩
展开
-
oracle中生成时间表
SELECT LEVEL + DATE '2019-11-01' dateFlag ,LEVEL + DATE '2019-11-01' dateF , trunc(dbms_random.value(1,50)) AS value FROM dualCONNECT BY LEVEL < DATE '2021-12-31' - DATE '2019-11-01' + 2原创 2022-01-03 20:59:54 · 911 阅读 · 0 评论 -
Hive中计算两个时间差的方式
(HOUR (CAST(applydet.RSV_END_DATE as timestamp) - CAST(applydet.rsv_begin_date as timestamp)) * 60 + MINUTE(CAST(applydet.RSV_END_DATE as timestamp) - CAST(applydet.rsv_begin_date as timestamp)) ) as minu ((unix_timestamp(applydet.RSV_END_DATE,'yyy.原创 2021-12-24 16:26:48 · 3022 阅读 · 0 评论 -
hive中查询数据为NULL,impala中查询数据可以正常显示
Impala是以序号形式读取parquet,而Hive是以列形式读取parquet原创 2021-07-15 11:20:59 · 1722 阅读 · 1 评论