使用Python从Teradata中检索输出

发布于 2025-02-13 22:25:46 字数 854 浏览 0 评论 0原文

是否有可能用Python检索Teradata中的产出?

例如。如果我执行从员工中解释选择 *;,是否有可能检索此问题?

 1) First, we lock a distinct TDUSER."pseudo table" for read on a
 RowHash to prevent global deadlock for TDUSER.employee.
 2) Next, we lock TDUSER.employee for read.
 3) We do an all-AMPs RETRIEVE step from TDUSER.employee by way of an
 all-rows scan with no residual conditions into Spool 1
 (group_amps), which is built locally on the AMPs. The size of
 Spool 1 is estimated with low confidence to be 2 rows (116 bytes).
 The estimated time for this step is 0.03 seconds.
 4) Finally, we send out an END TRANSACTION step to all AMPs involved
 in processing the request.
 → The contents of Spool 1 are sent back to the user as the result of
 statement 1. The total estimated time is 0.03 seconds.

我正在使用Teradatasql库现在。

Is there any possibility to retrieve explain output in Teradata with python?

Eg. if I execute EXPLAIN SELECT * FROM employee;, is there possibility to retrieve this?

 1) First, we lock a distinct TDUSER."pseudo table" for read on a
 RowHash to prevent global deadlock for TDUSER.employee.
 2) Next, we lock TDUSER.employee for read.
 3) We do an all-AMPs RETRIEVE step from TDUSER.employee by way of an
 all-rows scan with no residual conditions into Spool 1
 (group_amps), which is built locally on the AMPs. The size of
 Spool 1 is estimated with low confidence to be 2 rows (116 bytes).
 The estimated time for this step is 0.03 seconds.
 4) Finally, we send out an END TRANSACTION step to all AMPs involved
 in processing the request.
 → The contents of Spool 1 are sent back to the user as the result of
 statement 1. The total estimated time is 0.03 seconds.

I'm using teradatasql library now.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。
列表为空,暂无数据
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文