Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[idea] Window関数のサポート #751

Open
kaigai opened this issue Apr 17, 2024 · 0 comments
Open

[idea] Window関数のサポート #751

kaigai opened this issue Apr 17, 2024 · 0 comments
Labels
feature developer considers it is the feature to be supported on the future version
Milestone

Comments

@kaigai
Copy link
Contributor

kaigai commented Apr 17, 2024

前回のセミナーで質問が上がったやつ。
まず実装可能かどうか、色々な要素技術の検証が必要。

Window関数の特性上、必ずソート処理を伴う。
⇒GPU上のバッファに溜めておく仕組み(kds_finalに似た)が必要

GROUP-BYよりも遥かに多くのデータをバッファリングする必要がある
⇒Managed Memoryを使ってオーバーコミットした場合、どれくらいまで耐えられるのか。
(極端な速度低下が発生するなら、実行計画を立てる時の threshold が必要)

@kaigai kaigai added the feature developer considers it is the feature to be supported on the future version label Apr 17, 2024
@kaigai kaigai added this to the v6.0 milestone Dec 25, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature developer considers it is the feature to be supported on the future version
Projects
None yet
Development

No branches or pull requests

1 participant