locked
TIMESTAMP BY not working RRS feed

  • Question

  • Hi,

    I have a query that i wrote that is working when I use the default system time.

    When i do "by timestamp" i dont get any events.

    Query works in "Test" mode.

    I have an 18 day window for receiving messages (just expanded it because it wasnt working)

    No out of order.

    This is my datetime

    "dateTime\":\"2016-08-17T06:52:44Z"

    in my query i wrote "FROM IotHubEvents as deh TIMESTAMP BY [dateTime]"

    My locale is "united states english"

    Any help as to what im doing wrong?

    Thanks,

    Amir

    Wednesday, August 17, 2016 3:39 PM

Answers

  • What was start time of your job? Was it before or after dateTime? Please note that ASA will ignore all events before job start time (unless they are needed for query computation).

    • Marked as answer by Amir0 Thursday, August 18, 2016 10:16 AM
    Thursday, August 18, 2016 6:24 AM

All replies

  • What was start time of your job? Was it before or after dateTime? Please note that ASA will ignore all events before job start time (unless they are needed for query computation).

    • Marked as answer by Amir0 Thursday, August 18, 2016 10:16 AM
    Thursday, August 18, 2016 6:24 AM
  • I did not know that ASA will ignore all events before job start even if i use applicative time.

    Thanks.

    I will look into it further knowing this.

    -Amir

    Thursday, August 18, 2016 10:16 AM