aedelbro commented on issue #14800: URL: https://github.com/apache/druid/issues/14800#issuecomment-1675388481
@LakshSingla Thanks for the suggestion about doing the nested query for deduplication b/w the primary timestamp. Our current work around is doing some bitshifting magic to cram both timestamps into 1 (which we then discovered the bug [here](https://github.com/apache/druid/pull/14753)). The 64bit long is just a handful of bits too small to keep full precision. We set the lower 3 bits of `__time` to 0's then shift it 22 bits left, and right shift the secondary time column by 16 bits and add them together. 😅 Obviously just having a function to provided both columns is much cleaner 😄 -- 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]
