Hive months_between(日期相减不正确处理)
select floor(months_between(‘2022-02-28’, ‘2022-01-28’));
OK
_c0
1
Time taken: 0.133 seconds, Fetched: 1 row(s)
select floor(months_between(‘2022-02-28’, ‘2022-01-29’));
OK
_c0
0
Time taken: 0.103 seconds, Fetched: 1 row(s)
select floor(months_between(‘2022-02-28’, ‘2022-01-30’));
OK
_c0
0
Time taken: 0.093 seconds, Fetched: 1 row(s)
select floor(months_between(‘2022-02-28’, ‘2022-01-31’));
OK
_c0
1
Time taken: 0.092 seconds, Fetched: 1 row(s)
select months_between(‘2022-02-28’, ‘2022-01-28’);
OK
_c0
1.0
Time taken: 0.115 seconds, Fetched: 1 row(s)
select months_between(‘2022-02-28’, ‘2022-01-29’);
OK
_c0
0.96774194
Time taken: 0.086 seconds, Fetched: 1 row(s)
select months_between(‘2022-02-28’, ‘2022-01-3