Azure数据工厂CopyData活动问题,错误代码2200 [英] Azure Data Factory CopyData Activity issue, error code 2200
问题描述
我将使用Azure数据工厂计划数据库插入.
我正在复制1个数据和进行2次查找.1.在目标表中插入了最大ID(json代码中的LastValue).2.从源表中获得了最大id(最大值).
要获取复制数据"中的查找值,我编写了如下所述的查询,但仍然出现错误,无法在选择查询中获取查找值.
选择* 来自客户"的位置created_at> = getdate()-30和编号> @ {activity('CDNOps_LastUpdateValue').output.firstRow.LastValue}和ID< = @ {activity('Source_MaxValue').output.firstRow.Max limit 20000}
I am about to schedule the database insertion using Azure Data factory.
I am having 1 copy data and 2 lookups 1. Max Id inserted in destination table(LastValue in json code) 2. Max id from source table (Max).
To get the lookup value in Copy Data, i've written a query like i mentioned below but still i am getting error and i am unable to fetch Lookup value in select query.
select * from `customer` where created_at>=getdate()-30 and id > @{activity('CDNOps_LastUpdateValue').output.firstRow.LastValue} and id <= @{activity('Source_MaxValue').output.firstRow.Max limit 20000}
即使我关注了那么多博客,但没有任何事情使我失望.
even i followed so many blogs but nothing saved me out.
我在安排数据时收到的错误消息是,
" errorCode":" 2200" ;,
消息":在源"侧发生故障. ErrorCode = UserErrorOdbcOperationFailed,'类型= Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,消息=错误[42000] [Microsoft] [MariaDB]您的SQL语法错误;
检查与您的MariaDB服务器版本相对应的手册以获取正确的语法,以在第2行的'\"LastValue \":540418183} \ n和id< = {\"Max \":546239715}'附近使用. ........
The error message i am getting while scheduling the data is,
"errorCode": "2200",
"message": "Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [42000] [Microsoft][MariaDB] You have an error in your SQL syntax;
check the manual that corresponds to your MariaDB server version for the right syntax to use near '\"LastValue\":540418183}\n and id<={\"Max\":546239715}' at line 2.........
感谢&问候
Avinash K
Avinash K
推荐答案
您好,请参阅帖子
Hi there, see the post here.
这篇关于Azure数据工厂CopyData活动问题,错误代码2200的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!