asolimando commented on a change in pull request #3033:
URL: https://github.com/apache/hive/pull/3033#discussion_r814042293



##########
File path: ql/src/test/results/clientpositive/llap/subquery_scalar.q.out
##########
@@ -491,25 +484,25 @@ STAGE PLANS:
                 aggregations: count(VALUE._col0)
                 mode: mergepartial
                 outputColumnNames: _col0
-                Statistics: Num rows: 1 Data size: 196 Basic stats: COMPLETE 
Column stats: NONE
-                Limit
-                  Number of rows: 0
-                  Statistics: Num rows: 0 Data size: 0 Basic stats: COMPLETE 
Column stats: NONE
+                Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE 
Column stats: NONE
+                Filter Operator
+                  predicate: sq_count_check(_col0) (type: boolean)
+                  Statistics: Num rows: 1 Data size: 192 Basic stats: COMPLETE 
Column stats: NONE

Review comment:
       I agree that we must be conservative with this. 
   
   I managed to create a filter in line with what you suggested, it makes less 
sense but it's enough to showcase the improvement (explaining that in 
downstream projects we can have `false` too) and write a unit-test. 
   
   I will open a Calcite ticket and link the current one as "blocked by". 
   
   I will probably use the `Bug` class to keep track of this dependency and/or 
write a comment in `HiveRelMdPredicates` to describe the situation.




-- 
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]

Reply via email to