tgravescs commented on issue #27233: [SPARK-29701][SQL] Correct behaviours of group analytical queries when empty input given URL: https://github.com/apache/spark/pull/27233#issuecomment-577231870 so I'm I was curious what other sql engines did with this result because it seems weird to be to return count of 0 when you have no grouping and it seems Microsoft sql and oracle match what Spark does. So is this really a correctness issue vs just compatibility with Postgres? Postgres seems wrong here to me unless I'm missing something. If there are no keys how can you have a row with a count.
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
