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

Reply via email to