通过不生成输出使用TIMESTAMP进行基本查询 [英] Basic query with TIMESTAMP by not producing output

问题描述

我有一个非常基本的设置，如果使用TIMESTAMP BY语句，则永远不会得到任何输出.

I have a very basic setup, in which I never get any output if I use the TIMESTAMP BY statement.

我有一个流分析工作，它是从Event Hub读取并写入表存储的.

I have a stream analytics job which is reading from Event Hub and writing to the table storage.

查询如下:

SELECT
    * 
INTO
    MyOutput
FROM
    MyInput TIMESTAMP BY myDateTime;

如果查询使用timestamp语句，则永远不会获得任何输出事件.我确实在监视中看到传入事件，监视和维护日志中都没有错误.我很确定源数据的正确列格式正确.

If the query uses timestamp statement, I never get any output events. I do see incoming events in the monitoring, there are no errors neither in monitoring nor in the maintenance logs. I am pretty sure that the source data has the right column in the right format.

如果我删除了timestamp语句，那么一切工作正常.首先需要timestamp语句的原因是因为我需要在同一作业中编写多个查询，并将各种聚合写入不同的输出.而且，如果我在一个查询中使用时间戳，则必须在所有其他查询中使用它.

If I remove the timestamp statement, then everything is working fine. The reason why I need the timestamp statement in the first place is because I need to write a number of queries in the same job, writing various aggregations to different outputs. And if I use timestamp in one query, I am required to use it in all other queries itself.

我做错什么了吗?也许SELECT *在TIMESTAMP BY上不能很好地发挥作用?我只是没有找到任何说明这一点的文件...

Am I doing something wrong? Perhaps SELECT * does not play well with TIMESTAMP BY? I just did not find any documentation explaining that...

推荐答案

{"myDateTime":"2015-08-02T10:59:02.0000000Z"，"EventEnqueuedUtcTime":"2015-08-07T10:59:07.6980000Z }

{"myDateTime":"2015-08-02T10:59:02.0000000Z", "EventEnqueuedUtcTime":"2015-08-07T10:59:07.6980000Z"}

最后公差窗口:00.00:00:05

Late tolerance window: 00.00:00:05

您的所有事件都被视为延迟到达，因为myDateTime是EventEnqueuedUtcTime的5天之前.您是否可以尝试发送新事件，其中myDateTime处于UTC且为现在"，以便在几秒钟内匹配?

All of your events are considered late arriving because myDateTime is 5 days before EventEnqueuedUtcTime. Can you try sending new events where myDateTime is in UTC and is "now" so it matches within a couple of seconds?

另外，当您开始工作时，您选择了什么作为工作开始日期时间?您可以确定选择的日期早于myDateTime值吗?您可以先尝试一下.

Also, when you started the job, what did you pick as the job start date time? Can you make sure you pick a date before the myDateTime values? You might try this first.

这篇关于通过不生成输出使用TIMESTAMP进行基本查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！