Title: How to handle integer overflow in LogParser?
Tags: integer-overflow;logparser
Question: I'm selecting Sum(time-taken) from a big period of time logs and it is getting negative values. How do I handle it?
Comment: @GabrieleGiuseppini It worked. If you want, put an answer here and I'll accept it. Thank you.

Comment: You could try doing a sum of `TO_REAL(time-taken)`.

Here is the accepted answer: You could try doing a sum of TO_REAL(time-taken).


{'source': 'StackExchangeDataset', 'subset': 'stackoverflow.com', 'metadata': {'AnswerCount': 1, 'CommentCount': 2, 'ContentLicense': 'CC BY-SA 3.0', 'CreationDate': '2018:00:04/30/18', 'FavoriteCount': None, 'PostTypeId': 1, 'Tags': '<integer-overflow><logparser>', 'Title': 'How to handle integer overflow in LogParser?', 'ViewCount': 74, 'id': 50107852, 'user_AboutMe': '', 'user_AccountId': 6265792.0, 'user_DisplayName': 'lmcarreiro', 'user_Reputation': 4946.0, 'user_Views': 180.0, 'user_id': 4871582.0}}