英文:
Script activity vs lookup activity on ADF
问题
Script活动相对于Lookup有哪些优点？我知道Lookup存在一些限制，比如只能返回不超过1 MB的数据。在价格/性能/功能方面，Script活动是否有任何改进？我在网上找不到太多参考资料。
顺便说一下，Lookup 可以 用于运行不仅仅是 SELECT，还包括 UPDATE、DELETE、TRUNCATE 等操作，尽管看起来有点像一种 hack。
英文:
Is there a benefit of using Script activity over Lookup? I know that there are limits with Lookup like being able to return no more than 1 MB of data. Does Script activity have any improvements in terms of price/performance/feature? I could not find many references online.
BTW, Lookup can be used to run not only SELECT, but UPDATE, DELETE, TRUNCATE etc. too, albeit seeming like a hack.
答案1
得分: 2
- 查找活动不会阻止修改操作，但不建议使用查找活动来修改数据。
** 对于某些连接器，查找活动可以成功执行多个查询，但无法检索完整结果。
注意：返回结果集时要小心，因为活动输出限制为5000行/2MB大小。如果通过SQL脚本记录（打印语句），您可以通过选择用于记录的存储帐户来解决限制问题。
有关更多详细信息，请参阅脚本活动文档。
英文:
- Lookup activity does not block modify operations, but it is not recommended to use lookup activity to modify data.
** Multiple queries can be executed successfully in lookup activity for some connectors but cannot retrieve full result.
Note: Be careful when returning result sets, since the activity output is limited to 5000 row/ 2MB size. If you are logging through your SQL script (Print statements), you can work around the limit by choosing your Storage account for logging.
For more details, refer script activity documentation.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论