这就是你要找的吗？

SELECT t_date,start_date, holiday_count from biz_date as bd
INNER JOIN (SELECT COUNT(*) as holiday_count FROM holiday,biz_date as bd WHERE h_date BETWEEN bd.t_date AND bd.start_date) as holiday_count
ON 1=1

输出：

+-------------+-------------+----------------+--+
|   t_date    | start_date  | holiday_count  |
+-------------+-------------+----------------+--+
| 2018-12-31  | 2019-02-01  | 2              |
+-------------+-------------+----------------+--+

完整测试代码：

create table temp.biz_date (                                                                                                                                                                                     
t_date                  string
,start_date)
stored as parquet location '/temp.db/biz_date' tblproperties("parquet.compression=SNAPPY";

create table temp.biz_date(
t_date                   CHAR(10) 
, start_date             CHAR(10) )
stored as parquet location '/temp.db/biz_date' tblproperties("parquet.compression=SNAPPY") ;

INSERT INTO TABLE temp.holiday VALUES ('2019-01-01'),('2019-01-05');
INSERT INTO TABLE temp.biz_date  VALUES ('2018-12-31','2019-02-01');