[GitHub] [iceberg] zhangpanbigData commented on issue #2871: using insert overwrite clause in spark throw an exception

[GitBox <gi...@apache.org>]

zhangpanbigData commented on issue #2871:
URL: https://github.com/apache/iceberg/issues/2871#issuecomment-887133825


   > From first glance of the error message, first() here returns null?
   
   no，the first function works fine，below is the result：
   scala> spark.sql("select uuid,first(level),first(ts),first(message) from hive_catalog.icebergdb.logs where cast(ts as date)='2021-07-23' group by uuid").show(false)
   +------------------------------------+------------+-------------------+--------------+
   |uuid                                |first(level)|first(ts)          |first(message)|
   +------------------------------------+------------+-------------------+--------------+
   |db6a2c2a-93a8-443c-9e41-36cb214648f4|senior      |2021-07-23 17:24:03|the third row |
   |e41764f7-638b-4605-9642-f2b607d77c45|middle      |2021-07-23 17:24:03|the first row |
   +------------------------------------+------------+-------------------+--------------+


-- 
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.

To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org