Type promotion from Long to Timestamp <https://github.com/apache/iceberg/issues/9065> is on the roadmap for the V3 Spec, so that would be the preferred way.
On Wed, Apr 3, 2024 at 10:38 AM Jean-Baptiste Onofré <j...@nanthrax.net> wrote: > 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 >
