Hi Manu TIMESTAMP_LONG type promotion could be the easiest way, it would work with the existing transform.
Would it work for you? Regards JB On Wed, Apr 3, 2024 at 5:56 AM Manu Zhang <owenzhang1...@gmail.com> wrote: > > Hi all, > > We have source data with a timestamp field in LONG type to land in an Iceberg > table. We want to partition the table with the timestamp field such that we > can query recent data more efficiently. However, LONG is not supported as the > source type of time-based transform (hour, day, etc) > > I find the previous discussion https://github.com/apache/iceberg/issues/417 > and Ryan suggested two solutions > > 1. type promotion from LONG to TIMESTAMP > 2. custom transform > > As I understand it, neither solution has already been implemented yet. Is > there any progress in either direction? Which solution does the community > prefer? Any other suggestions are also appreciated. > > Thanks, > Manu
