SQL DW-Polybase错误 [英] SQL DW - Polybase Error

问题描述

在将polybase与sql DW一起使用时，我遇到了一个问题.每当datetime字段中的所有行都为null时，创建外部表时在SQL DW中出错.但是，如果我在文件中至少输入了一个虚拟日期值，则该行有效 很好.您能告诉我使用polybase(azure数据湖存储文件)时为日期数据类型标识空值的sql DW是否有任何限制.

I am facing an issue while using polybase with sql DW. Whenever I have null for all rows in the datetime field , I am getting error in SQL DW while creating external table.However if I enter a dummy date value in the file at least for one row , it is working fine.Can you pls let me know if there is any limitations of sql DW of identifying null values for date data types while using polybase (azure data lake store file).

谢谢

Soumitra.

推荐答案

嗨Soumitra，

Hi Soumitra,

Polybase会将NULL字符串视为NULL值.您有两种选择:

Polybase is going to treat NULL string as NULL value. You have a couple options:

您可以将列定义更改为接受NULL值吗.

Can you change your column definition to accept NULL values.

或者您可以利用Azure Data Factory中的Polybase在加载时执行其他步骤来控制/清理数据:

Or you can leverage Polybase within Azure Data Factory to perform additional steps at load time to control/scrub the data: Copy data to or from Azure SQL Data Warehouse by using Azure Data Factory

我  ;希望有帮助！

I hope this helps!

此致

迈克

这篇关于SQL DW-Polybase错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！