Azure数据工厂：无效的URI：Uri方案太长 [英] Azure Data Factory : Invalid URI: The Uri scheme is too long

问题描述

我在Azure Data Factory中使用Copy活动将数据从Http Source复制到datalake。我的Url包含sql查询作为查询参数。我得到"无效的URI：Uri方案太长"错误。

I am using a Copy activity in Azure Data Factory to copy the data from Http Source to datalake. My Url contains sql query as a query param. Iam getting "Invalid URI: The Uri scheme is too long" error.

可能的错误条件：

Possible Error conditions:

1.带有更多列的SQL查询where子句中的select语句和日期条件 - 抛出错误

1.SQL query with more column in the select statement and date condition in the where clause- Error is thrown

2.SQL查询更多选择语句中的
列  和字符串字段i n where子句 - 无错误

2.SQL query with more column in the select statement and string field in the where clause - No Error

3. SQL查询少选择语句中的
列  和日期 where子句中的
条件  - 无错误

3. SQL query with less column in the select statement and date condition in the where clause - No Error

API如下所示： 

API looks like the below one: 

http://example.com/api/query?q=从表格中选择a，b，c，d ......日期> =''和日期< ;''

http://example.com/api/query?q=select a,b,c,d...... from table where date >= ' ' and date < ' '

我很感激任何帮助。

I'd appreciate any help on this.

推荐答案

你好，

你的URI是否超过2000个字符？我在网上看到有关该错误的引用，表明这是问题。如果你调用的端点支持POST方法，你可能会得到通过将
的查询放入邮件正文中，围绕字符限制。

Is your URI longer than 2000 characters? I am seeing references on the web for that error that suggests that is the problem.  If the endpoint you are calling supports the POST method, you may be able to get around the character limitation by putting your query in the message body.

这篇关于Azure数据工厂：无效的URI：Uri方案太长的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！