xiaoyutongxue6的博客

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

(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.

Impala是以序号形式读取parquet，而Hive是以列形式读取parquet