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

Implement master_aggregate_table_shards(source table, destination table, aggregation_query) #11

Closed
ozgune opened this issue Feb 1, 2016 · 3 comments

Comments

@ozgune
Copy link
Contributor

ozgune commented Feb 1, 2016

Our documentation refers to the user-defined function master_aggregate_table_shards to help users create distributed materialized views. We need to implement this function or remove the reference to it from our documentation.

https://www.citusdata.com/documentation/citusdb-documentation/examples/id_querying_aggregated_data.html

The mechanism through which we implement this function could potentially be similar to #10

@ozgune
Copy link
Contributor Author

ozgune commented Nov 2, 2016

@onderkalaci -- Now that we implemented INSERT INTO (SELECT ...) with #508, what do you think about closing this issue?

@onderkalaci
Copy link
Member

https://www.citusdata.com/documentation/citusdb-documentation/examples/id_querying_aggregated_data.html

The link is dead, so I cannot see what the UDF is intended for. If it only intends to make co-located roll-ups, INSERT INTO .. SELECT already does that with a wide SQL coverage. But, if it intends to run arbitrary multi-shard roll-ups, it might make sense to keep the issue open.

@ozgune
Copy link
Contributor Author

ozgune commented Nov 11, 2016

Good point. The intent with this user-defined function was to roll-up data from a source distributed table to a target colocated table. I'm therefore closing this issue.

@ozgune ozgune closed this as completed Nov 11, 2016
thanodnl added a commit that referenced this issue Nov 5, 2020
DESCRIPTION: add pushdown support for projections and quals in table access method scan

This implementation uses custom scans to push projections into the scans on a columnar table. The custom scan replaces all access paths to a table to force the projection of the columns.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants