You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by GitBox <gi...@apache.org> on 2021/12/31 09:56:44 UTC
[GitHub] [spark] gongzh021 opened a new pull request #35081: Branch 3.0 [v3.0.2] [sql] [union all] One of the SQL returns (number of output rows: 0) Cause the whole sql to die
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: reviews-unsubscribe@spark.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org
[GitHub] [spark] HyukjinKwon commented on pull request #35081: Branch 3.0 [v3.0.2] [sql] [union all] One of the SQL returns (number of output rows: 0) Cause the whole sql to die
Posted by GitBox <gi...@apache.org>.
HyukjinKwon commented on pull request #35081:
URL: https://github.com/apache/spark/pull/35081#issuecomment-1003351976
Please file an issue in JIRA: https://issues.apache.org/jira/projects/SPARK
--
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: reviews-unsubscribe@spark.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org
[GitHub] [spark] gongzh021 commented on pull request #35081: Branch 3.0 [v3.0.2] [sql] [union all] One of the SQL returns (number of output rows: 0) Cause the whole sql to die
Posted by GitBox <gi...@apache.org>.
gongzh021 commented on pull request #35081:
URL: https://github.com/apache/spark/pull/35081#issuecomment-1003329482
It can be determined that the first SQL has no results returned.
--
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: reviews-unsubscribe@spark.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org
[GitHub] [spark] HyukjinKwon closed pull request #35081: Branch 3.0 [v3.0.2] [sql] [union all] One of the SQL returns (number of output rows: 0) Cause the whole sql to die
Posted by GitBox <gi...@apache.org>.
HyukjinKwon closed pull request #35081:
URL: https://github.com/apache/spark/pull/35081
--
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: reviews-unsubscribe@spark.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org