gongzh021 opened a new pull request #35081:
URL: https://github.com/apache/spark/pull/35081
As the title indicates.
I encountered this problem.
Spark2.4.7 can be successfully executed and the result data can be
successfully obtained.
I am very confused
Hope to get answers or ideas from the community.
The following is the SQL statement (Some fields are decorated.)：
**select h_code ,sum(box_num) box_num
from
(
select h_code,box_num
from dm.stock_info
where dt='2021-12-23' and code in ('100') and box_num>0
union all
SELECT h_code,sum(field1) as box_num
from dw.order_item1 where dt='2021-12-23'
and is_finish =0 and is_valid=1 and to_date(order_time)>='2021-12-07'
and code='100' and box_num>0
GROUP by h_code
union ALL
select h_code,sum(field1) as box_num
from dw.order_item2
where dt='2021-12-23' and is_valid=1 and is_pay=1 and is_rk=0 and is_close=0
and is_delete=0 and to_date(pay_date)>='2021-12-07'
and code='100'
group by h_code
)aa
group by h_code**
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
