2025年11月17日

Python - Don't forget the ',' when define a tuple

摘要： root_ids = ('abcd') root_ids_tuple = ('abcd',) root_ids_list = ['abcd'] print(type(root_ids)) print(' ') print([f"'{item}'" for item in root_ids]) pri 阅读全文

posted @ 2025-11-17 14:06 ZhangZhihuiAAA 阅读(7) 评论(0) 推荐(0)

Spark SQL - Recursive CTE example

摘要： WITH RECURSIVE filtered_org_ids AS ( SELECT organizationresourceid, parentresourceid FROM tmp_org WHERE organizationresourceid = '123456' UNION SELECT 阅读全文

posted @ 2025-11-17 10:38 ZhangZhihuiAAA 阅读(61) 评论(0) 推荐(0)

Spark SQL - Recursive CTE

摘要： Can you give me an example to query parent-child hierarchy using Spark SQL recursive CTE? ChatGPT said: Sure! Here are clear, complete Spark SQL examp 阅读全文

posted @ 2025-11-17 09:31 ZhangZhihuiAAA 阅读(15) 评论(0) 推荐(0)


博客园 © 2004-2026 浙公网安备 33010602011771号浙ICP备2021040463号-3

导航

2025年11月17日