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

[BUG] Unable to install re_data for Greenplum database #100

Closed
mrprigun opened this issue Oct 24, 2022 · 0 comments
Closed

[BUG] Unable to install re_data for Greenplum database #100

mrprigun opened this issue Oct 24, 2022 · 0 comments
Labels
bug Something isn't working

Comments

@mrprigun
Copy link
Contributor

Describe the bug
There is an error when running the command dbt run --models package:re_data

Expected behavior
re_data models installed for Greenplum database.

To Reproduce
Steps to reproduce the behavior:

  • Configure dbt project for Greenplum database
  • Run command dbt run --models package:re_data

Screenshots
image

Logs and additional context

...
14:27:46 Completed with 1 error and 0 warnings:
14:27:46  
14:27:46  Database Error in model re_data_last_stats (models/metrics/for_anomalies/re_data_last_stats.sql)
14:27:46    column "re_data_base_metrics.value" must appear in the GROUP BY clause or be used in an aggregate function
14:27:46    LINE 12:         avg(value)  over(partition by table_name, column_nam...
14:27:46                         ^
14:27:46    compiled SQL at target/run/re_data/models/metrics/for_anomalies/re_data_last_stats.sql
...

There're four places hardcoded for PostgreSQL database in models/metrics/for_anomalies/re_data_last_stats.sql file.

image

Greenplum is based on PostgreSQL 9.4 and has the same syntax. So it should be changed to something like this:

image

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants