marton-bod commented on issue #5590: URL: https://github.com/apache/iceberg/issues/5590#issuecomment-1248172706
Yep, the work we did was exactly that, to expose this existing Iceberg functionality via SQL syntax. See PR: https://github.com/apache/hive/pull/3222 It was ultimately abandoned, because we wanted to reuse the SQL standard `FOR SYSTEM TIME BETWEEN ... AND ....`, but the semantics of what Iceberg returns (appends that happened during this time period) is different than the semantics of the SQL standard (returns all rows that were active during this time period - so rows could have been appended before the time window as well). At the time we found no justification for introducing a new, Hive-specific SQL syntax for this. -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
