SNOW-1889503: [Local Testing] Group by in empty dataframe adds "phantom" row with NULL group by key

[miguelaraujo2]

Please answer these questions before submitting your issue. Thanks!

1. What version of Python are you using?

3.11.11

2. What operating system and processor architecture are you using?

Linux-6.8.0-51-generic-x86_64-with-glibc2.39

3. What are the component versions in the environment (pip freeze)?

N/A

4. What did you do?

   Performing a group by on an empty dataframe produces a dataframe with a row where the key is NULL.

Simple reproducible example:

from snowflake.snowpark import Session
from snowflake.snowpark.functions import when_matched, when_not_matched, col, sum

session = Session.builder.config('local_testing', True).create()

df = session.create_dataframe([[1, 5]], schema=['id', 'count'])

df.filter(col("id") > 1).group_by(col("id")).agg(sum(col("count")).alias("count")).show()

5. What did you expect to see?

   An empty DataFrame should be shown.
   However, we obtain the following output:

------------------
|"ID"  |"COUNT"  |
------------------
|NULL  |nan      |
------------------

6. Can you set logging to DEBUG and collect the logs?
   N/A