Push Down regr_ Functions
Maintainers usually reply within 1 day
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 68/100
Research direction
Start by locating the existing pushdown handling for PostgreSQL functions and the ClickHouse version checks. Add coverage for the nine listed regr_* functions on ClickHouse 26.9 and newer, and verify that older versions do not receive unsupported pushdown; run the relevant existing tests for function pushdown.
Written by the indexing model from the issue text.
Description
ClickHouse 26.9 added Postgres-compatible regr_* functions. Add pushdown support for them on 26.9 and higher. List:
- regr_avgx(double precision, double precision) double precision
- regr_avgy(double precision, double precision) double precision
- regr_count(double precision, double precision) bigint
- regr_intercept(double precision, double precision) double precision
- regr_r2(double precision, double precision) double precision
- regr_slope(double precision, double precision) double precision
- regr_sxx(double precision, double precision) double precision
- regr_sxy(double precision, double precision) double precision
- regr_syy(double precision, double precision) double precision
- Dominant language
- C
- Stars
- 284
- Forks
- 21
- Avg merge
- 23h 1m
- Merged PRs (30d)
- 20
Getting set up
We have not checked this project's setup files yet. Start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from ClickHouse/pg_clickhouse
-
Difficulty 1/5 1-3 hours Newbie friendliness 88/100
ClickHouse/pg_clickhouse#383 · 1 comment ·
Maintainers usually reply within 1 day
-
data types enhancement
Difficulty 5/5 Over a week Newbie friendliness 35/100
ClickHouse/pg_clickhouse#380 ·
Maintainers usually reply within 1 day
-
Push down joins against an aggregated `IN (SELECT … GROUP BY … HAVING)` subquery (TPC-H Q18 shape)Possibly taken @JoshDreamland claimed this 2 days ago. Openenhancement pushdown sql
ClickHouse/pg_clickhouse#378 · 1 assignee ·
Maintainers usually reply within 1 day
-
operators pushdown
Difficulty 3/5 1-2 days Newbie friendliness 65/100
ClickHouse/pg_clickhouse#375 ·
Maintainers usually reply within 1 day
-
Nested Type IssuesPossibly taken @serprex claimed this 5 days ago. Openbug data types
ClickHouse/pg_clickhouse#372 · 7 comments · 2 assignees ·
Maintainers usually reply within 1 day
All issues in ClickHouse/pg_clickhouse
Similar issues
-
bug needs triage
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
netdata/netdata#24062 · 1 comment ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 76/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
riscv-software-src/riscv-isa-sim#2448 ·
Maintainers usually reply within 2 days
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
-
Difficulty 1/5 Under an hour Newbie friendliness 75/100
NabuCasa/silabs-firmware-builder#231 · 1 comment ·