"[Solved] Retrieve Unix timestamps"

BartNBartN MemberPosts:18Maven
edited June 2019 inHelp
The Retrieve operator does not seem to correctly retrieve stored unix timestamps (as read from a database for example). The timestamps are long values and in the example below valid values upon storage are for example 1348646704669. The value after retrieval is like 2147483647. The last three digits seem to be missing and corrupt the data. The following reproduces this problem. Does anyone has an idea how to correctly store and retrieve these long values?





<宏/ >




























[/ code]
Tagged:

Answers

  • MariusHelfMariusHelf RapidMiner Certified Expert, MemberPosts:1,869Unicorn
    Hi,

    the integer data type in RapidMiner can only handle values up to 2^31. You can work around that by converting the round values after Real to Integer back to Real before storing them.

    However, I created an internal bug report from your process, since the behaviour is at best unexpected.

    Best, Marius
  • BartNBartN MemberPosts:18Maven
    Hi Marius,

    Thanks for the solution, It worked.
    Presumably the Store format in the repository does not support long ints.
    The Result View in Rapid shows the complete value for the Integer type.
    意想不到的。

    Kind regards,
    Bart
  • BartNBartN MemberPosts:18Maven

    Hi Marius,

    Was the bug ever solved? When passing unix time values back and forth to a Groovy script, it still seems to overflow to a large integer.

Sign InorRegisterto comment.