设置引号字符导致不符合条件的条件以直接运行Polybase复制 [英] Setting Quote character causing Conditions are not met to run polybase copy directly

问题描述

我有一个CSV输入文件，该文件使用逗号(，)分隔. CSV中还有一些可能带有逗号字符的值，但是这些值都用引号()括起来，这是标准的CSV方式.

I have a CSV input files which is delimited using commas(,). There are also values in the CSV that may have a comma character, however these values are enclosed in quotes("), which is standard CSV way.

这是使用复制活动将数据加载到Azure数据仓库中.为了避免复制活动用逗号分隔值，我将数据集上的引号字符(quoteChar)设置为"quotes(").但是当我运行活动时 我收到以下错误

This is data is loaded into a Azure DataWarehouse using a copy activity. To avoid the copy activity from splitting the value's with commas in them I set the Quote Character (quoteChar) on the DataSet to quotes("). However when I run the activity I get the following error

已设置引用字符.不满足直接运行Polybase复制的条件，请指定存储帐户

我想polybase加载不喜欢必须处理带引号的字符串.有解决方案/解决方法吗?

I suppose polybase loads don't like having to deal with quoted strings. Is there a solution/workaround for this?

推荐答案

我相信系统会提示您使用暂存副本:

I believe you are being prompted to use Staged Copy:

https ://docs.microsoft.com/zh-cn/azure/data-factory/connector-azure-sql-data-warehouse#staged-copy-by-using-polybase

有关分阶段复制的更多信息:

Here is more information on Staged Copy:

https://docs.microsoft.com/zh-CN -us/azure/data-factory/copy-activity-performance#staged-copy 如果您愿意尝试此操作，则需要提供一个Blob存储帐户.  

If you are willing to try this out, you will need to supply a Blob Storage account.  

这篇关于设置引号字符导致不符合条件的条件以直接运行Polybase复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！