Can we remove timestamp from hive.operations table?
AFAIK all operations in a given block have the stame timestamp. And hive.operations has a block_num attached to the block and it has a timestamp, so HAF seems to be storing a bunch of timestamps there for no good reason. There is a created_at timestamp in the block itself (which is always 3s after the timestamp of all the operations, which is probably some meaningless artifact of the way timestamps are being assigned by hived). I suspect we could simply drop the timestamp column in operations table and replace it by created_in timestamp in block (or worst case, replace it after substracting 3s).
Edited by Dan Notestein