日期时间过滤器 [英] Date Time Filter

问题描述

您好，

当前，我正在尝试通过ADF实现增量加载.每次我运行复制活动时，我都会看到数据翻了一番，存储在天蓝色表中.那就是如果我的源表中有50行，并且如果我从源到暂存运行了两次我的工作(Azure表) 存储空间)有100行.当我尝试过滤时，出现错误，并且没有任何行返回.

表存储中存在的

DateTime就像这样

解决方案

1.源和接收器都是天蓝色的表存储，对吗?

2.请按照此文档链接. >

如果您的源列属于DateTime类型，则应按以下方式更改查询:

" azureTableSourceQuery" ;: {
                            值":"CREATEDDATE gt datetime'@ {activity('Lookup1').output.firstRow.LASTRUNDATE}'和CREATEDDATE lt datetime'@ {activity('Lookup1').output.firstRow.CURRENTDATE}' ，
                            类型":表达"；
                        } 

3.如果上述方法不起作用，请提供失败活动ID和错误消息.

Hi Team,

Currently I am trying to implement incremental load via ADF. Every time I run my copy Activity I see the data gets doubled to azure table storage. That is if there are 50 rows in my source table and If I run twice my job from Source to Staging(Azure Table Storage)  has 100 rows. When I try to filter I am getting errors and none of the rows are return.

DateTime present in Table Storage is like this

解决方案

1. Both your source and sink are azure table storage, right?

2. Please follow this doc link.

If your source column is of DateTime type, you should change your query as following:

"azureTableSourceQuery": {
                            "value": "CREATEDDATE gt  datetime'@{activity('Lookup1').output.firstRow.LASTRUNDATE}' and CREATEDDATE lt datetime'@{activity('Lookup1').output.firstRow.CURRENTDATE}"',
                            "type": "Expression"
                        }

3. If above doesn't work, please provided the failure activity id and the error message.

这篇关于日期时间过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！