dongjoon-hyun 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-577950755 @maropu . I use Docker. For example, the following is `Oracle` docker case. ```bash ~$ docker run --name oracle -d -p 8080:8080 -p 1521:1521 store/oracle/database-enterprise:12.2.0.1 ~$ docker exec -it oracle /bin/bash [oracle@e24398d6fa62 /]$ cd $ORACLE_HOME [oracle@e24398d6fa62 dbhome_1]$ bin/sqlplus / as sysdba SQL*Plus: Release 12.2.0.1.0 Production on Fri Jan 24 01:07:04 2020 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> create table gstest_empty (a integer, b integer, v integer); Table created. SQL> select a, b, sum(v), count(*) from gstest_empty group by grouping sets ((a,b),()); no rows selected ``` MsSQL is the same. ```bash $ docker run --name mssql -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=Sapass123' -p 1433:1433 -d mcr.microsoft.com/mssql/server:2017-GA-ubuntu $ docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P "Sapass123" ```
---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org
