Github user robbinspg commented on the issue:
https://github.com/apache/spark/pull/17039
ok so here is an example of output I'm not sure is correct:
in-order-by
-- !query 17
SELECT Count(DISTINCT( t1a )),
t1b
FROM t1
WHERE t1h NOT IN (SELECT t2h
FROM t2
where t1a = t2a
order by t2d DESC nulls first
)
GROUP BY t1a,
t1b
ORDER BY t1b DESC nulls last
-- !query 17 schema
struct<count(DISTINCT t1a):bigint,t1b:smallint>
-- !query 17 output
1 10
1 10
1 16
1 6
1 8
1 NULL
That is the "new" output with your change but it doesn't actually match
what you'd expect from that query (it isn't t1b DESC) which would be
1 16
1 10
1 10
1 8
1 6
1 NULL
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
