Ilam Kanniah
05/01/2025, 4:34 PMLONG datatype and we would now like to add a timestamp index to that field but realized that the index can only be applied on TIMESTAMP datatype.
Changing the data type is not a backward compatible change and fails schema update even though the underlying physical value stored is in long format for both.
Is the only approach to add a new column and migrate to that column / table with all the data. I was wondering if the index can support datetimespec LONG value or the schema update can be done from LONG to TIMESTAMP instead in-place. Let me know what you think. thanksMayank
Ilam Kanniah
05/01/2025, 4:41 PM