从读取Synapse DWH的表格时,Azure Synapse异常
从桌子上读书时我得到
jdbc.sqlserverexception:创建外部表作为sect语句失败,因为路径#######无法将其用于导出。 错误代码:105005
While reading from table I'm getting
jdbc.SQLServerException : Create External Table As Sect statement failed as the path ####### could not be used for export.
Error Code :105005
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
由于polybase 无法完成操作,因此发生了此错误。操作故障可能是由于以下原因引起的:
您可以通过遵循此问题来解决此问题=“ nofollow noreferrer”> 文章 它可以帮助您解决当您执行
创建外部表格为select
时发生的问题。有关更多详细信息,请请参阅下面的链接:
https://learn.microsoft.com/en-us/troubleshoot/sql/analytics-platform-system/error-cetas-cetas-cetas-cetas-cetas-cetas-cetas-cetas-cetas-cetas-cetas-cetas-to-blob-storage
https> https> https://wwwww.sqlservercentral central。 com/articles/access-external-data-from-azure-synapse-analytics-using-polybase
https://knowledge.informatica.com/s/article/000175628?language= en_us
This error occurs because of PolyBase can't complete the operation. The operation failure can be due to the following reasons :
You can fix this issue by following this article it helps you resolve the problem that occurs when you do a
CREATE EXTERNAL TABLE AS SELECT
.For more in detail, please refer below links:
https://learn.microsoft.com/en-us/troubleshoot/sql/analytics-platform-system/error-cetas-to-blob-storage
https://www.sqlservercentral.com/articles/access-external-data-from-azure-synapse-analytics-using-polybase
https://knowledge.informatica.com/s/article/000175628?language=en_US