search

trinodb / trino

Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (https://trino.io)
https://trino.io
Apache License 2.0
10.15k stars 2.93k forks source link

Support time travel in Delta Lake connector #15894

Closed gui-elastic closed 5 months ago

gui-elastic commented 1 year ago

Hello,

I saw that Trino already has the time travel feature on Iceberg, so I am opening this issue to discuss plans for adding time travel support for Delta Lake. This would ideally support timestamps:

SELECT count(*) FROM my_table FOR SYSTEM_TIME AS OF "2019-01-01"

or with versions

SELECT count(*) FROM my_table FOR SYSTEM_VERSION AS OF 5238
kevinclcn commented 1 year ago

Which version is this issue planned for?

Guilherme-Silveira commented 1 year ago

I'm also interested to know that. I am not from Trino Community. I just also want this feature available.

cxl-todd commented 1 year ago

I'm also very interested in this feature. Has any work on this begun yet?

Visorgood commented 11 months ago

Plus one from my side +1. This feature would enable several use-cases in my company.

whitleykeith commented 11 months ago

+1 as well

andrii-fadieiev commented 10 months ago

Here is my +1

VardhanDeva commented 9 months ago

+1 as well