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

ClickHouse Incremental Model file name must match output #6374

Open
royendo opened this issue Jan 7, 2025 · 0 comments
Open

ClickHouse Incremental Model file name must match output #6374

royendo opened this issue Jan 7, 2025 · 0 comments
Labels
Type:Bug Something isn't working

Comments

@royendo
Copy link
Contributor

royendo commented Jan 7, 2025

Describe the bug
When creating an incremental model using Clickhouse as the OLAP engine, the output name of the model (in Clickhouse) must match the name in Rill.

If not, when selecting "Generate metrics with AI" it will load forever. Selecting "simple" will fail.

To Reproduce
Using the below YAML, create a file with a name different than AdBids_csv.yaml and try to create a metrics with AI

type: model
materialize: true
incremental: true

sql: >
  SELECT timestamp, id, bid_price, domain, publisher
  FROM gcs('https://storage.googleapis.com/playwright-gcs-qa/AdBids_csv.csv',
          'CSV', 'timestamp DateTime, id UInt32, bid_price Double, domain String, publisher String'
        )
  {{ if dev }} LIMIT 100 {{ end }}

output:
  table: AdBids_csv
  engine: MergeTree

Expected behavior
Regardless of the name of the file in Rill, this should be able to generate the metrics with AI.

Screenshots
https://www.loom.com/share/319dfeda04384cd7a7652b29c1da3f16?from_recorder=1&focus_title=1

@royendo royendo added the Type:Bug Something isn't working label Jan 7, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Type:Bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant